On Wed, Jul 15, 2009 at 12:59 PM, Lee, Mija<mija@scharp.org> wrote:
> Hi -
> I'm not a particularly experienced dba, so I'm hoping this isn't a
> ridiculous question.
> I have a 5 GB table with lots of churn in a 14 GB database. Querying
> this one table without limits has just started throwing "out of memory
> for query" from multiple clients (psql, java).
If you're getting this error on the client side (i.e. it's not message
coming from pgsql, it's coming from the client software) nothing you
do on the server configuration / partitioning wise is going to help.
Accessing the data via a cursor is usually the best way around that error.