Re: vacuum, performance, and MVCC
От | Jan Wieck |
---|---|
Тема | Re: vacuum, performance, and MVCC |
Дата | |
Msg-id | 449CE1C0.7020309@Yahoo.com обсуждение исходный текст |
Ответ на | Re: vacuum, performance, and MVCC ("Mark Woodward" <pgsql@mohawksoft.com>) |
Ответы |
Re: vacuum, performance, and MVCC
|
Список | pgsql-hackers |
On 6/23/2006 3:10 PM, Mark Woodward wrote: > This is NOT an "in-place" update. The whole MVCC strategy of keeping old > versions around doesn't change. The only thing that does change is one > level of indirection. Rather than keep references to all versions of all > rows in indexes, keep only a reference to the first or "key" row of each > row, and have the first version of a row form the head of a linked list to > subsequent versions of each row. The list will be in decending order. Where exactly do you intend to keep all those links (for a table with N indexes)? Jan -- #======================================================================# # It's easier to get forgiveness for being wrong than for being right. # # Let's break this rule - forgive me. # #================================================== JanWieck@Yahoo.com #
В списке pgsql-hackers по дате отправления: