Re: More shared buffers causes lower performances

Поиск
Список
Период
Сортировка
От Simon Riggs
Тема Re: More shared buffers causes lower performances
Дата
Msg-id 1198668065.4221.288.camel@ebony.site
обсуждение исходный текст
Ответ на More shared buffers causes lower performances  ("Guillaume Smet" <guillaume.smet@gmail.com>)
Ответы Re: More shared buffers causes lower performances  ("Guillaume Smet" <guillaume.smet@gmail.com>)
Re: More shared buffers causes lower performances  ("Guillaume Smet" <guillaume.smet@gmail.com>)
Список pgsql-performance
On Wed, 2007-12-26 at 01:06 +0100, Guillaume Smet wrote:

> I lowered the number of concurrent clients to 50 because 100 is quite
> high and I obtain the same sort of results:
> shared_buffers=32MB: 1869 tps
> shared_buffers=64MB: 1844 tps
> shared_buffers=512MB: 1676 tps
> shared_buffers=1024MB: 1559 tps

Can you try with

bgwriter_lru_maxpages = 0

So we can see if the bgwriter has any hand in this?

--
  Simon Riggs
  2ndQuadrant  http://www.2ndQuadrant.com


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

Предыдущее
От: Cédric Villemain
Дата:
Сообщение: Re: More shared buffers causes lower performances
Следующее
От: "Guillaume Smet"
Дата:
Сообщение: Re: More shared buffers causes lower performances