Re: [GENERAL] Autovacuum Improvements

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: [GENERAL] Autovacuum Improvements
Дата
Msg-id 16600.1169784800@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: [GENERAL] Autovacuum Improvements  (Bruce Momjian <bruce@momjian.us>)
Ответы Re: [GENERAL] Autovacuum Improvements  (Bruce Momjian <bruce@momjian.us>)
Список pgsql-hackers
Bruce Momjian <bruce@momjian.us> writes:
> Jim C. Nasby wrote:
>> If we extended relations by more than one page at a time we'd probably
>> have a better shot at the blocks on disk being contiguous and all read
>> at the same time by the OS.

> Actually, there is evidence that adding only a single page to the end
> causes a lot of contention for that last page, and that adding a few
> might be better.

Evidence where?  The code is designed so that the last page *isn't*
shared --- go read the comments in hio.c sometime.
        regards, tom lane


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

Предыдущее
От: Jan Wieck
Дата:
Сообщение: Proposal: Snapshot cloning
Следующее
От: Bruce Momjian
Дата:
Сообщение: Re: [GENERAL] Autovacuum Improvements