Re: Postgres using up all my memory - Mailing list pgsql-general

From Eric Jain
Subject Re: Postgres using up all my memory
Date
Msg-id 42038E14.5050100@isb-sib.ch
Whole thread Raw
In response to Re: Postgres using up all my memory  (Stephan Szabo <sszabo@megazone.bigpanda.com>)
List pgsql-general
Stephan Szabo wrote:
> Explain output would also be useful.  I would wonder if it's a problem
> with a hash that misestimated the necessary size; you might see if
> analyzing the tables involved changes its behavior.

I executed ANALYZE just before running the problematic statement. Will
post the output of EXPLAIN, if no other explanation comes up.

pgsql-general by date:

Previous
From: Shawn Harrison
Date:
Subject: Re: [OT] PostgreSQL: bytea help needed.
Next
From: Bricklen Anderson
Date:
Subject: Re: Invalid headers and xlog flush failures