Re: Huge amount of memory consumed during transaction

From: Richard Huxton <dev(at)archonet(dot)com>
To: henk de wit <henk53602(at)hotmail(dot)com>
Cc: "pgsql-performance(at)postgresql(dot)org" <pgsql-performance(at)postgresql(dot)org>
Subject: Re: Huge amount of memory consumed during transaction
Date: 2007-10-11 14:16:20
Message-ID: 470E3034.8020309@archonet.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

henk de wit wrote:
> Hi,
>
> I'm running into a problem with PostgreSQL 8.2.4 (running on 32 bit
> Debian Etch/2x dual core C2D/8GB mem). The thing is that I have a
> huge transaction that does 2 things: 1) delete about 300.000 rows
> from a table with about 15 million rows and 2) do some (heavy)
> calculations and re-insert a litlte more than 300.000 new rows.
>
> My problem is that this consumes huge amounts of memory.

What exactly consumes all your memory? I'm assuming it's not just
straight SQL.

--
Richard Huxton
Archonet Ltd

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message Scott Marlowe 2007-10-11 14:27:23 Re: Huge amount of memory consumed during transaction
Previous Message henk de wit 2007-10-11 14:04:38 Huge amount of memory consumed during transaction