Re: Index-only scan performance regression

Поиск
Список
Период
Сортировка
От Robert Haas
Тема Re: Index-only scan performance regression
Дата
Msg-id CA+Tgmobvyn28tNzEWfToAFavWU17=dR+mtoSgkspFmfWMBvJow@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Index-only scan performance regression  (Dean Rasheed <dean.a.rasheed@gmail.com>)
Ответы Re: Index-only scan performance regression  (Dean Rasheed <dean.a.rasheed@gmail.com>)
Список pgsql-hackers
On Tue, Jan 31, 2012 at 2:15 PM, Dean Rasheed <dean.a.rasheed@gmail.com> wrote:
> In the case when we're asked to clear a bit, it would first try to pin
> the relevant page, which would go through vm_readbuf() with extend set
> to true. Then vm_extend() would notice that the visibility map had
> already been extended, and it would read in the new page with the set
> bit. So this case would continue to work, wouldn't it?

Ah, maybe.  I haven't tried to code it up.  Do you want to take a crack at it?

-- 
Robert Haas
EnterpriseDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company


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

Предыдущее
От: Merlin Moncure
Дата:
Сообщение: Re: JSON for PG 9.2
Следующее
От: Martijn van Oosterhout
Дата:
Сообщение: Re: [GENERAL] pg_dump -s dumps data?!