Re: Storage space lost during an UPDATE - Mailing list pgsql-novice

From Vitaly Belman
Subject Re: Storage space lost during an UPDATE
Date
Msg-id ccn240$sqe@odah37.prod.google.com
Whole thread Raw
In response to Storage space lost during an UPDATE  (Vitaly Belman <vitalyb@gmail.com>)
List 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


pgsql-novice by date:

Previous
From: Ennio-Sr
Date:
Subject: Re: [LONG] Need help on pg_dump!
Next
From: Tom Lane
Date:
Subject: Re: .pgpass