Re: wal_buffers, redux

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

In response to

Browse pgsql-hackers by date

  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