Re: Storage space lost during an UPDATE

Поиск
Список
Период
Сортировка
От Vitaly Belman
Тема Re: Storage space lost during an UPDATE
Дата
Msg-id ccn240$sqe@odah37.prod.google.com
обсуждение исходный текст
Ответ на Storage space lost during an UPDATE  (Vitaly Belman <vitalyb@gmail.com>)
Список 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 по дате отправления:

Предыдущее
От: Ennio-Sr
Дата:
Сообщение: Re: [LONG] Need help on pg_dump!
Следующее
От: Tom Lane
Дата:
Сообщение: Re: .pgpass