subject:"\[GENERAL\] Out of memory on SELECT \(from sort\?\) in 8.3"

Re: [GENERAL] Out of memory on SELECT (from sort?) in 8.3

2008-09-25 Thread Matt Magoffin

Huh, I was overthinking the problem. xml_out has a memory leak :-( More than one in fact: a large leak (equal to size of output) in the executor context (hence query lifespan) and a small one in LibxmlContext (hence transaction lifespan). Try the patch here:

Re: [GENERAL] Out of memory on SELECT (from sort?) in 8.3

2008-09-25 Thread Tom Lane

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

[GENERAL] Out of memory on SELECT (from sort?) in 8.3

-- Thread Matt Magoffin

oding="utf-8"?> mercedes http://www.mail-archive.com/mercedes@okiebenz.com mercedes @ okiebenz Sun, 14 Sep 2008 21:59:21 GMT Sun, 14 Sep 2008 21:59:21 GMT http://blogs.law.harvard.edu/tech/rss MHonArc RSS 2.0 RCFile themailarchive@gmail.com (The Mail Archive)