Re: What are effective methods for retriving many number of rows from postgreSQL tables using perl DBI?

[perrin]

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.