| From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
|---|---|
| To: | Kevin Murphy <murphy(at)genome(dot)chop(dot)edu> |
| Cc: | DANTE ALEXANDRA <ALEXANDRA(dot)DANTE(at)BULL(dot)NET>, Chris Browne <cbbrowne(at)acm(dot)org>, pgsql-general(at)postgresql(dot)org |
| Subject: | Re: out of memory during query execution |
| Date: | 2005-12-20 17:14:42 |
| Message-ID: | 661.1135098882@sss.pgh.pa.us |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
Kevin Murphy <murphy(at)genome(dot)chop(dot)edu> writes:
> I'm certainly not an AIX expert, but I remember my 32-bit AIX programs
> being limited to 256MB of heap by default.
Hmm ... if that's the case then it'd probably explain the problem.
Alexandra had work_mem set to 64MB, so the two hashes and sort would
think they could use 3/4ths of the available heap; given that there
are other needs and our management of memory-use limitations is fairly
sloppy, that could easily translate into running out.
So the answer is either to increase the available heap or reduce
work_mem to a smaller fraction of it.
regards, tom lane
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Mag Gam | 2005-12-20 17:50:52 | tsearch2: index in different table? |
| Previous Message | DANTE ALEXANDRA | 2005-12-20 16:57:09 | Re: out of memory during query execution |