Postgres Pro
Downloads
Home   >   mailing lists

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

From Guillaume Smet
Subject Re: More shared buffers causes lower performances
Date
Msg-id 1d4e0c10712260455w7eda7fc1s4d23b43de5270152@mail.gmail.com
Whole thread Raw
In response to Re: More shared buffers causes lower performances  (Simon Riggs <simon@2ndquadrant.com>)
List pgsql-performance
Tree view 
On Dec 26, 2007 12:21 PM, Simon Riggs <simon@2ndquadrant.com> wrote:
> Can you try with
>
> bgwriter_lru_maxpages = 0
>
> So we can see if the bgwriter has any hand in this?

I will. I'm currently running tests with less concurrent clients (16)
with exactly the same results:
64M 4213.314902
256M 4012.782820
512M 3676.840722
768M 3377.791211
1024M 2863.133965
64M again 4274.531310

I'm rerunning the tests using Greg Smith's pgbench-tools [1] to obtain
a graph of each run.

[1] http://www.westnet.com/~gsmith/content/postgresql/pgbench-tools.htm

--
Guillaume

pgsql-performance by date:

Previous
From: "Guillaume Smet"
Date:
Subject: Re: More shared buffers causes lower performances
Next
From: "Fernando Hevia"
Date:
Subject: With 4 disks should I go for RAID 5 or RAID 10