"Matt Magoffin" <[EMAIL PROTECTED]> 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 -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general