Postgres Pro
Downloads
Home   >   mailing lists

Re: Out of Memory - Mailing list pgsql-admin

From Tom Lane
Subject Re: Out of Memory
Date
Msg-id 3023.1162875154@sss.pgh.pa.us
Whole thread Raw
In response to Re: Out of Memory  (Abu Mushayeed <abumushayeed@yahoo.com>)
List pgsql-admin
Tree view 
Abu Mushayeed <abumushayeed@yahoo.com> writes:
> I really could appreciate some help.

If nothing else, "set enable_hashagg = off" should help.  But have you
analyzed these tables lately?  Perhaps you have work_mem set too high?

            regards, tom lane

pgsql-admin by date:

Previous
From: Bruno Wolff III
Date:
Subject: Re: I have a question about Database management
Next
From: adey
Date:
Subject: Re: How do I adjust max_fsm_pages