RE: Possible performance improvement: buffer replacemen t policy

Поиск
Список
Период
Сортировка
От Mikheev, Vadim
Тема RE: Possible performance improvement: buffer replacemen t policy
Дата
Msg-id 8F4C99C66D04D4118F580090272A7A234D329F@sectorbase1.sectorbase.com
обсуждение исходный текст
Список pgsql-hackers
> > Tom, did we ever test this?  I think we did and found that 
> > it was the same or worse, right?
> 
> I tried it and didn't see any noticeable improvement on the particular
> test case I was using, so I got discouraged and didn't pursue the idea
> further.  I'd like to come back to it someday, though.

I don't know how much useful could be LRU-2 but with WAL we should try
to reuse undirty free buffers first, not dirty ones, just to postpone
writes as long as we can. (BTW, this is what Oracle does.)
So, we probably should put new free dirty buffer just before first
undirty one in LRU.

Vadim


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

Предыдущее
От: Bruce Momjian
Дата:
Сообщение: Re: Possible performance improvement: buffer replacement policy
Следующее
От: Tom Lane
Дата:
Сообщение: Re: Re: [PATCHES] s_lock.h cleanup