Re: Experimental patch for inter-page delay in VACUUM

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Experimental patch for inter-page delay in VACUUM
Дата
Msg-id 15456.1067796035@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: Experimental patch for inter-page delay in VACUUM  (Jan Wieck <JanWieck@Yahoo.com>)
Ответы Re: Experimental patch for inter-page delay in VACUUM
Re: Experimental patch for inter-page delay in VACUUM
Список pgsql-hackers
Jan Wieck <JanWieck@Yahoo.com> writes:
> I am currently looking at implementing ARC as a replacement strategy. I 
> don't have anything that works yet, so I can't really tell what the 
> result would be and it might turn out that we want both features.

It's likely that we would.  As someone (you?) already pointed out,
VACUUM has bad side-effects both in terms of cache flushing and in
terms of sheer I/O load.  Those effects require different fixes AFAICS.

One thing that bothers me here is that I don't see how adjusting our
own buffer replacement strategy is going to do much of anything when
we cannot control the kernel's buffer replacement strategy.  To get any
real traction we'd have to go back to the "take over most of RAM for
shared buffers" approach, which we already know to have a bunch of
severe disadvantages.
        regards, tom lane


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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: Avoiding SIGPIPE (was Re: OSDL DBT-2 w/ PostgreSQL
Следующее
От: AgentM
Дата:
Сообщение: Re: Avoiding SIGPIPE (was Re: OSDL DBT-2 w/ PostgreSQL