Re: Bug: Buffer cache is not scan resistant

Поиск
Список
Период
Сортировка
От Simon Riggs
Тема Re: Bug: Buffer cache is not scan resistant
Дата
Msg-id 1173694117.3641.536.camel@silverbirch.site
обсуждение исходный текст
Ответ на Re: Bug: Buffer cache is not scan resistant  ("Simon Riggs" <simon@2ndquadrant.com>)
Ответы Re: Bug: Buffer cache is not scan resistant  (ITAGAKI Takahiro <itagaki.takahiro@oss.ntt.co.jp>)
Re: Bug: Buffer cache is not scan resistant  ("Luke Lonergan" <llonergan@greenplum.com>)
Re: Bug: Buffer cache is not scan resistant  (Bruce Momjian <bruce@momjian.us>)
Re: Bug: Buffer cache is not scan resistant  (Bruce Momjian <bruce@momjian.us>)
Список pgsql-hackers
On Mon, 2007-03-12 at 09:14 +0000, Simon Riggs wrote:
> On Mon, 2007-03-12 at 16:21 +0900, ITAGAKI Takahiro wrote:

> > With the default
> > value of scan_recycle_buffers(=0), VACUUM seems to use all of buffers in pool,
> > just like existing sequential scans. Is this intended?
>
> Yes, but its not very useful for testing to have done that. I'll do
> another version within the hour that sets N=0 (only) back to current
> behaviour for VACUUM.

New test version enclosed, where scan_recycle_buffers = 0 doesn't change
existing VACUUM behaviour.

--
  Simon Riggs
  EnterpriseDB   http://www.enterprisedb.com


Вложения

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

Предыдущее
От: "Simon Riggs"
Дата:
Сообщение: Re: Bug: Buffer cache is not scan resistant
Следующее
От: Galy Lee
Дата:
Сообщение: Re: autovacuum next steps, take 3