Re: Postgres using up all my memory

From: Eric Jain <Eric(dot)Jain(at)isb-sib(dot)ch>
To: Stephan Szabo <sszabo(at)megazone(dot)bigpanda(dot)com>
Cc: pgsql-general <pgsql-general(at)postgresql(dot)org>
Subject: Re: Postgres using up all my memory
Date: 2005-02-04 15:00:36
Message-ID: 42038E14.5050100@isb-sib.ch
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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.

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Bricklen Anderson 2005-02-04 15:07:15 Re: Invalid headers and xlog flush failures
Previous Message Shawn Harrison 2005-02-04 14:56:37 Re: [OT] PostgreSQL: bytea help needed.