From: | Bruno Wolff III <bruno(at)wolff(dot)to> |
---|---|
To: | Stephan Szabo <sszabo(at)megazone(dot)bigpanda(dot)com> |
Cc: | Eric Jain <Eric(dot)Jain(at)isb-sib(dot)ch>, pgsql-general <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: Postgres using up all my memory |
Date: | 2005-02-04 14:42:25 |
Message-ID: | 20050204144225.GD18206@wolff.to |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
On Fri, Feb 04, 2005 at 05:59:26 -0800,
Stephan Szabo <sszabo(at)megazone(dot)bigpanda(dot)com> wrote:
> On Fri, 4 Feb 2005, Eric Jain wrote:
>
> > I'm trying to fill a table with several million rows that are obtained
> > directly from a complex query.
> >
> > For whatever reason, Postgres at one point starts using several
> > gigabytes of memory, which eventually slows down the system until it no
> > longer responds.
> > Any ideas? Is this a known problem, or should Postgres be able to handle
> > this? May be tricky to reproduce the problem, as a lot of data is
> > required, but I can post the DDL/DML statements I am using if this helps.
>
> 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 think deferred triggers can also use a lot of memory.
From | Date | Subject | |
---|---|---|---|
Next Message | Magnus Hagander | 2005-02-04 14:47:06 | Re: Postgresql 8.0 beta 5 setup in windowsxp |
Previous Message | Sean Davis | 2005-02-04 14:35:59 | Re: mysql load_file() function |