in reply to What are effective methods for retriving many number of rows from postgreSQL tables using perl DBI?

As the docs say, "the execute method fetches all data at once into data structures located in the front-end application. This approach must to be considered when selecting large amounts of data!" I think you will have to use cursors if you want to get around this problem.
  • Comment on Re: What are effective methods for retriving many number of rows from postgreSQL tables using perl DBI?