| From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
|---|---|
| To: | "Matt Magoffin" <postgresql(dot)org(at)msqr(dot)us> |
| Cc: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: Out of memory on SELECT (from sort?) in 8.3 |
| Date: | 2008-09-26 00:15:33 |
| Message-ID: | 1468.1222388133@sss.pgh.pa.us |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
"Matt Magoffin" <postgresql(dot)org(at)msqr(dot)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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Frederik Ramm | 2008-09-26 00:25:38 | Re: Various intermittent bugs/instability - how to debug? |
| Previous Message | Casey Allen Shobe | 2008-09-25 23:38:18 | Re: Obfuscated stored procedures (was Re: Oracle and Postgresql) |