Re: Resumable vacuum proposal and design overview

Поиск
Список
Период
Сортировка
От Heikki Linnakangas
Тема Re: Resumable vacuum proposal and design overview
Дата
Msg-id 45E6ED0F.5030104@enterprisedb.com
обсуждение исходный текст
Ответ на Re: Resumable vacuum proposal and design overview  ("Jim C. Nasby" <jim@nasby.net>)
Список pgsql-hackers
Jim C. Nasby wrote:
> On Wed, Feb 28, 2007 at 10:14:24PM +0000, Heikki Linnakangas wrote:
>> cache instead. In the index scan phase, it's randomly accessed, but if 
>> the table is clustered, it's in fact not completely random access. In 
>> the 2nd vacuum pass, the array is scanned sequentially again. I'm not 
> 
> Only if there's only one index on the table... otherwise I'd argue that
> you're much less likely to be searching the TID list incrementally.

Yeah, sure.

--   Heikki Linnakangas  EnterpriseDB   http://www.enterprisedb.com


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

Предыдущее
От: "Jim C. Nasby"
Дата:
Сообщение: Re: Resumable vacuum proposal and design overview
Следующее
От: "Pavan Deolasee"
Дата:
Сообщение: Re: HOT - preliminary results