Re: Bug: Buffer cache is not scan resistant

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Bug: Buffer cache is not scan resistant
Дата
Msg-id 15267.1173709819@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: Bug: Buffer cache is not scan resistant  (ITAGAKI Takahiro <itagaki.takahiro@oss.ntt.co.jp>)
Ответы Re: Bug: Buffer cache is not scan resistant  ("Simon Riggs" <simon@2ndquadrant.com>)
Список pgsql-hackers
ITAGAKI Takahiro <itagaki.takahiro@oss.ntt.co.jp> writes:
> I tested your patch with VACUUM FREEZE. The performance was improved when
> I set scan_recycle_buffers > 32. I used VACUUM FREEZE to increase WAL traffic,
> but this patch should be useful for normal VACUUMs with backgrond jobs!

Proving that you can see a different in a worst-case scenario is not the
same as proving that the patch is useful in normal cases.
        regards, tom lane


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

Предыдущее
От: "Simon Riggs"
Дата:
Сообщение: Re: Synchronized Scan update
Следующее
От: Tom Lane
Дата:
Сообщение: Re: autovacuum next steps, take 3