Re: out of memory error - Mailing list pgsql-admin

From Tom Lane
Subject Re: out of memory error
Date
Msg-id 2097.1281021521@sss.pgh.pa.us
Whole thread Raw
In response to Re: out of memory error  (Silvio Brandani <silvio.brandani@tech.sdb.it>)
List pgsql-admin
Silvio Brandani <silvio.brandani@tech.sdb.it> writes:
>> "Kevin Grittner" <Kevin.Grittner@wicourts.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

pgsql-admin by date:

Previous
From: Silvio Brandani
Date:
Subject: Re: out of memory error
Next
From: "xsun"
Date:
Subject: The function of lock file named ".s.PGSQL..lock" on Linux?