Re: Vacuum thoughts

Поиск
Список
Период
Сортировка
От Neil Conway
Тема Re: Vacuum thoughts
Дата
Msg-id 1066423711.581.58.camel@tokyo
обсуждение исходный текст
Ответ на Vacuum thoughts  (Greg Stark <gsstark@mit.edu>)
Ответы Re: Vacuum thoughts  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-hackers
On Fri, 2003-10-17 at 16:22, Greg Stark wrote:
> If it's just a matter of all the read i/o from vacuum then we're best off
> sleeping for a few milliseconds every few kilobytes. If it's the cache then
> we're probably better off reading a few megabytes and then sleeping for
> several seconds to allow the other buffers to get touched and pushed back to
> the front of the LRU.

Uh, no -- if it is the cache, we're better off fixing the buffer
replacement policy, not trying to hack around it. Replacement policies
that don't suffer from sequential flooding are well known.

-Neil




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

Предыдущее
От: "Joshua D. Drake"
Дата:
Сообщение: Writers Wanted
Следующее
От: "Matthew T. O'Connor"
Дата:
Сообщение: Re: Some thoughts about i/o priorities and throttling vacuum