| From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
|---|---|
| To: | Silvio Brandani <silvio(dot)brandani(at)tech(dot)sdb(dot)it> |
| Cc: | Kevin Grittner <Kevin(dot)Grittner(at)wicourts(dot)gov>, pgsql-admin(at)postgresql(dot)org |
| Subject: | Re: out of memory error |
| Date: | 2010-08-05 15:18:41 |
| Message-ID: | 2097.1281021521@sss.pgh.pa.us |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin |
Silvio Brandani <silvio(dot)brandani(at)tech(dot)sdb(dot)it> writes:
>> "Kevin Grittner" <Kevin(dot)Grittner(at)wicourts(dot)gov> writes:
>>> What query?
[ query with aggregates and GROUP BY ]
Does EXPLAIN show that it's trying to use a hash aggregation plan?
If so, try turning off enable_hashagg. I think the hash table might
be ballooning far past the number of entries the planner expected.
Do you have an idea how many groups there should be in the query
result?
regards, tom lane
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Scott Marlowe | 2010-08-05 16:13:41 | Re: out of memory error |
| Previous Message | Silvio Brandani | 2010-08-05 14:29:37 | Re: out of memory error |