We use cookies for personalised adverts on this site. PayPal donation is another mechanism for support if you prefer.

hosted services

  • why unix
  • wet shaving
  • unix beards
  • about this site
  • books
  • RBL service
  • forum
This site needs your support
amountGBP

News

Ads help server costs, we rely on their revenue (and donations, too) to fund hosting.

perl and mostly postgresql

    This page is a brain dump from using perl. Mostly with postgres and the few problems that I have encountered.

    Firstly, this is something that caught be by surprise. When you execute a statement, such as the one below, the result set will be held in memory by the perl process.

    $sth = $dbh->execute( "select * from t" );
    

    It does not matter which type of fetch you do following this, the result will end up in the perl process. See the following note:

    DBD::Pg cursors

    This is a shame since it means that very large select result would be inefficient and potentially cause the system to swap.

    Last modified: 1556742102.77