Re: Storage space lost during an UPDATE

From: "Vitaly Belman" <vitalyb(at)gmail(dot)com>
To: pgsql-novice(at)postgresql(dot)org
Subject: Re: Storage space lost during an UPDATE
Date: 2004-07-09 21:18:56
Message-ID: ccn240$sqe@odah37.prod.google.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

Ah, I understand. Thanks :).

Steve Crawford wrote:
> This is expected. It has to do with MVCC, not commit. PostgreSQL
> creates a duplicate record for each record that was updated. This is
> how MVCC hangs on to "old" records that may still be in use by other
> transactions.
>
<SNIP>
>
> Cheers,
> Steve

Browse pgsql-novice by date

  From Date Subject
Next Message Tom Lane 2004-07-10 00:59:40 Re: .pgpass
Previous Message Ennio-Sr 2004-07-09 21:18:45 Re: [LONG] Need help on pg_dump!