| From: | "Guillaume Smet" <guillaume(dot)smet(at)gmail(dot)com> |
|---|---|
| To: | "Simon Riggs" <simon(at)2ndquadrant(dot)com> |
| Cc: | pgsql-performance <pgsql-performance(at)postgresql(dot)org>, "Stefan Kaltenbrunner" <stefan(at)kaltenbrunner(dot)cc> |
| Subject: | Re: More shared buffers causes lower performances |
| Date: | 2007-12-26 12:55:15 |
| Message-ID: | 1d4e0c10712260455w7eda7fc1s4d23b43de5270152@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-performance |
On Dec 26, 2007 12:21 PM, Simon Riggs <simon(at)2ndquadrant(dot)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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Fernando Hevia | 2007-12-26 15:15:03 | With 4 disks should I go for RAID 5 or RAID 10 |
| Previous Message | Guillaume Smet | 2007-12-26 12:47:01 | Re: More shared buffers causes lower performances |