Re: Lock problem with autovacuum truncating heap

Поиск
Список
Период
Сортировка
От Itagaki Takahiro
Тема Re: Lock problem with autovacuum truncating heap
Дата
Msg-id AANLkTi=GSe6CwLdgQ1MMscLShGL02TYVL2uaXhmsWsXQ@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Lock problem with autovacuum truncating heap  (Simon Riggs <simon@2ndQuadrant.com>)
Ответы Re: Lock problem with autovacuum truncating heap
Список pgsql-hackers
On Sun, Mar 27, 2011 at 01:12, Simon Riggs <simon@2ndquadrant.com> wrote:
>> At the same time I would
>> change count_nondeletable_pages() so that it uses a forward scan direction
>> (if that leads to a speedup).

+1.

> Do we need that? Linux readahead works in both directions doesn't it?
> Guess it wouldn't hurt too much.

Yes, probably. AFAIK, RHEL 5 cannot readahead in backward scans.
It might be improved in the latest kernel, but it would be safe
not to rely on kernels except simple forward scans.

-- 
Itagaki Takahiro


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

Предыдущее
От: Martijn van Oosterhout
Дата:
Сообщение: Re: Open issues for collations
Следующее
От: Robert Haas
Дата:
Сообщение: Re: race condition in sync rep