| From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
|---|---|
| To: | "Abu Mushayeed" <amushayeed(at)hotmail(dot)com> |
| Cc: | pgsql-admin(at)postgresql(dot)org |
| Subject: | Re: Out of memory error |
| Date: | 2006-06-23 17:18:18 |
| Message-ID: | 16806.1151083098@sss.pgh.pa.us |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin |
"Abu Mushayeed" <amushayeed(at)hotmail(dot)com> writes:
> AFTER A WHILE THE SYSTEM COMES BACK AND SAYS IN THE LOG FILE:
Please turn off your caps lock key :-(
> AggContext: -1501569024 total in 351 blocks; 69904 free (507 chunks);
> -1501638928 used
> DynaHashTable: 302047256 total in 46 blocks; 275720 free (66 chunks);
> 301771536 used
Hm, it's evidently misjudging how much memory will be needed by a
HashAggregate plan, probably because it's underestimating the number
of GROUP BY groups. Could we see the EXPLAIN output for the query?
What PG version is this exactly? Have you ANALYZEd the table lately?
regards, tom lane
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Daniel Xavier de Sousa | 2006-06-23 18:32:35 | Buffers to Nest Loop Join |
| Previous Message | Abu Mushayeed | 2006-06-23 17:05:51 | Out of memory error |