Re: vacuum, performance, and MVCC

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: vacuum, performance, and MVCC
Дата
Msg-id 6992.1151010374@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: vacuum, performance, and MVCC  (Jim Nasby <jnasby@pervasive.com>)
Список pgsql-hackers
Jim Nasby <jnasby@pervasive.com> writes:
> Question: do we currently create new index entries even if the index  
> key hasn't changed?

Yes.

> If so, what's the purpose of storing the CTID of  
> the next version in the old version of the row?

So that UPDATE can always find the newest version of the row,
independently of what indexes exist or how it got to the row.
You may care to re-read the second paragraph here:
http://developer.postgresql.org/docs/postgres/transaction-iso.html#XACT-READ-COMMITTED
        regards, tom lane


В списке pgsql-hackers по дате отправления:

Предыдущее
От: Stefan Kaltenbrunner
Дата:
Сообщение: Re: Overhead for stats_command_string et al, take 2
Следующее
От: Tom Lane
Дата:
Сообщение: Re: Overhead for stats_command_string et al, take 2