"Matt Magoffin" <postgresql.org@msqr.us> writes:
>> Try the patch here:
>> http://archives.postgresql.org/pgsql-committers/2008-09/msg00159.php
> I've applied this patch now to our staging and production environments,
> and Postgres performed quite well after testing very large result sets
> that were previously failing with out of memory errors... so the patch is
> successful for this problem I was having. I didn't see any significant
> increase in memory over the course of the query execution, in fact.
Good to hear. That patch is baked into 8.3.4, if you want to go back to
using a stock release...
regards, tom lane