Re: [HACKERS] Trivial patch to double vacuum speed on tables with no indexes

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: [HACKERS] Trivial patch to double vacuum speed on tables with no indexes
Дата
Msg-id 13384.1157406328@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: [HACKERS] Trivial patch to double vacuum speed  (Bruce Momjian <bruce@momjian.us>)
Ответы Re: [HACKERS] Trivial patch to double vacuum speed  (Bruce Momjian <bruce@momjian.us>)
Список pgsql-patches
Bruce Momjian <bruce@momjian.us> writes:
> Patch applied.  Thanks.

Wait a minute.   This patch changes the behavior so that
LockBufferForCleanup is applied to *every* heap page, not only the ones
where there are removable tuples.  It's not hard to imagine scenarios
where that results in severe system-wide performance degradation.
Has there been any real-world testing of this idea?

            regards, tom lane

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

Предыдущее
От: Bruce Momjian
Дата:
Сообщение: Re: [HACKERS] Trivial patch to double vacuum speed
Следующее
От: Bruce Momjian
Дата:
Сообщение: Re: [HACKERS] Trivial patch to double vacuum speed