Re: Bgwriter strategies

Поиск
Список
Период
Сортировка
От Heikki Linnakangas
Тема Re: Bgwriter strategies
Дата
Msg-id 468E19CF.8040004@enterprisedb.com
обсуждение исходный текст
Ответ на Re: Bgwriter strategies  (Greg Smith <gsmith@gregsmith.com>)
Ответы Re: Bgwriter strategies
Список pgsql-hackers
Greg Smith wrote:
> As you can see, I achieved the goal of almost never having a backend 
> write its own buffer, so yeah for that.  That's the only good thing I 
> can say about it though.  The TPS results take a moderate dive, and 
> there's about 10% more buffer allocations.  The big and obvious issues 
> is that I'm writing almost 75% more buffers this way--way worse even 
> than the 10% extra overhead Heikki was seeing.  But since I've going out 
> of my way to find a worse-case for this code, I consider mission 
> accomplished there.

There's something wrong with that. The number of buffer allocations 
shouldn't depend on the bgwriter strategy at all.

--   Heikki Linnakangas  EnterpriseDB   http://www.enterprisedb.com


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

Предыдущее
От: Greg Smith
Дата:
Сообщение: Re: Bgwriter strategies
Следующее
От: Greg Smith
Дата:
Сообщение: Re: Bgwriter strategies