Re: Experimental patch for inter-page delay in VACUUM

Поиск
Список
Период
Сортировка
От Matthew T. O'Connor
Тема Re: Experimental patch for inter-page delay in VACUUM
Дата
Msg-id 3FA2E007.4040801@zeut.net
обсуждение исходный текст
Ответ на Re: Experimental patch for inter-page delay in VACUUM  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-hackers
Tom Lane wrote:

>"Stephen" <jleelim@xxxxxx.com> writes:
>  
>
>>Great! I haven't tried it yet, but I love the thought of it already :-)
>>I've been waiting for something like this for the past 2 years and now it's
>>going to make my multi-gigabyte PostgreSQL more usable and responsive. Will
>>the delay be tunable per VACUUM invocation?
>>    
>>
>
>As the patch is set up, you just do "SET vacuum_page_delay = n" and
>then VACUUM.
>  
>
probably a setting that autovacuum will tweak based on things like table 
size etc.... If we can find a way to automatically tweak it that makes 
sense.



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

Предыдущее
От: Neil Conway
Дата:
Сообщение: out of date bufmgr README
Следующее
От: Tom Lane
Дата:
Сообщение: Re: out of date bufmgr README