Postgres Pro
Downloads
Home   >   mailing lists

Re: More shared buffers causes lower performances - Mailing list pgsql-performance

From Simon Riggs
Subject Re: More shared buffers causes lower performances
Date
Msg-id 1198668065.4221.288.camel@ebony.site
Whole thread Raw
In response to More shared buffers causes lower performances  ("Guillaume Smet" <guillaume.smet@gmail.com>)
Responses Re: More shared buffers causes lower performances
Re: More shared buffers causes lower performances
List pgsql-performance
Tree view 
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 by date:

Previous
From: Cédric Villemain
Date:
Subject: Re: More shared buffers causes lower performances
Next
From: "Guillaume Smet"
Date:
Subject: Re: More shared buffers causes lower performances