Longer startup delay (was Re: Single Index Tuple Chain (SITC) method)

Поиск
Список
Период
Сортировка
От Alvaro Herrera
Тема Longer startup delay (was Re: Single Index Tuple Chain (SITC) method)
Дата
Msg-id 20060629170833.GA7756@surnet.cl
обсуждение исходный текст
Ответ на Re: Single Index Tuple Chain (SITC) method  (Tom Lane <tgl@sss.pgh.pa.us>)
Ответы Re: Longer startup delay (was Re: Single Index Tuple Chain (SITC) method)  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-hackers
Tom Lane wrote:

> Another issue is that this would replace a simple hint-bit setting with
> an index change that requires a WAL entry.  There'll be more WAL traffic
> altogether from backends retail-deleting index tuples than there would
> be from VACUUM cleaning the whole page at once

Speaking of which, I think I've noticed a longer delay in server start
after initdb.  I haven't measured nor profiled it, but I think it may be
because of the heap_inplace_update xlogging that we weren't doing
previously.

-- 
Alvaro Herrera                                http://www.CommandPrompt.com/
The PostgreSQL Company - Command Prompt, Inc.


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

Предыдущее
От: Hannu Krosing
Дата:
Сообщение: Re: Single Index Tuple Chain (SITC) method
Следующее
От: Martijn van Oosterhout
Дата:
Сообщение: Re: Single Index Tuple Chain (SITC) method