From: | Robert Haas <robertmhaas(at)gmail(dot)com> |
---|---|
To: | Andres Freund <andres(at)anarazel(dot)de> |
Cc: | pgsql-hackers(at)postgresql(dot)org, Jeff Janes <jeff(dot)janes(at)gmail(dot)com> |
Subject: | Re: wal_buffers, redux |
Date: | 2012-03-13 22:23:33 |
Message-ID: | CA+TgmoYKy8+bp4UoF3tS0hYpcfJ5q+pz7w6bEJu+GqiW=_g8Ng@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
On Tue, Mar 13, 2012 at 4:55 AM, Andres Freund <andres(at)anarazel(dot)de> wrote:
> On Tuesday, March 13, 2012 03:26:34 AM Robert Haas wrote:
>> Meanwhile, here are some TPS graphs at 16MB and 32MB on the IBM POWER7
>> machine. 32 clients, 1800 seconds, scale factor 300, synchronous
>> commit off.
> That graph makes me cringe because its pretty representative of what I have
> seen in practise. Any chance we can get a ~10s average in there? I find it
> pretty hard to read more than "spikey".
I tried that but don't find it an improvement; however I'm attaching
an example for your consideration.
> Whats the filesystem + options on this?
ext4, default options. Fedora 16, 3.2.6-3.fc16.ppc64.
--
Robert Haas
EnterpriseDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company
Attachment | Content-Type | Size |
---|---|---|
image/png | 10.1 KB |
From | Date | Subject | |
---|---|---|---|
Next Message | Robert Haas | 2012-03-13 22:30:19 | Re: pg_upgrade and statistics |
Previous Message | Robert Haas | 2012-03-13 22:20:46 | Re: wal_buffers, redux |