Re: bgwriter changes

Поиск
Список
Период
Сортировка
От Zeugswetter Andreas DAZ SD
Тема Re: bgwriter changes
Дата
Msg-id 46C15C39FEB2C44BA555E356FBCD6FA40184D277@m0114.s-mxs.net
обсуждение исходный текст
Ответ на bgwriter changes  (Neil Conway <neilc@samurai.com>)
Список pgsql-hackers
> > Only if you redefine the meaning of bgwriter_percent.  At present it's
> > defined by reference to the total number of dirty pages, and that can't
> > be known without collecting them all.
> >
> > If it were, say, a percentage of the total length of the T1/T2 lists,
> > then we'd have some chance of stopping the scan early.

> The other way around would make sense. In order to avoid writing the
> busiest buffers at all (except for checkpoinging), the parameter should
> mean "don't scan the last x% of the queue at all".

Your meaning is 1 - above meaning (at least that is what Tom and I meant),
but is probably easier to understand (== Informix LRU_MIN_DIRTY).

> Still, we need to avoid scanning over all the clean blocks of a large
> buffer pool, so there is need for a separate dirty-LRU.

Maybe a "may be dirty" bitmap would be easier to do without beeing deadlock prone ?

Andreas


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

Предыдущее
От: Peter Eisentraut
Дата:
Сообщение: Re: getting 'order by' working with unicode locale? ICU?
Следующее
От: Neil Conway
Дата:
Сообщение: Re: bgwriter changes