Re: Large Result and Memory Limit

Mike Ginsburg wrote:
> Hello,
>  I am working on a personnel registry that has upwards of 50,000
> registrants.  Currently I am working on an export module that will create a
> CSV from multiple tables.  I have managed to keep the script (PHP) under
> the memory limit when creating and inserting the CSV into the database.
> The problem comes when I try to query for the data and export it.  Memory
> limit is a major concern, but the query for one row returns a result set
> too large and PHP fails.

One row?  Wow, I didn't know PHP was that broken.

Try declaring a cursor and fetching a few rows at a time.

--
Alvaro Herrera                               http://www.PlanetPostgreSQL.org/
"No es bueno caminar con un hombre muerto"