Skip site navigation (1) Skip section navigation (2)

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: (view raw, whole thread or download thread mbox)
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
The Enterprise PostgreSQL Company

Attachment: tps-16MB-10s.png
Description: image/png (10.1 KB) (inlined above)

In response to

pgsql-hackers by date

Next:From: Robert HaasDate: 2012-03-13 22:30:19
Subject: Re: pg_upgrade and statistics
Previous:From: Robert HaasDate: 2012-03-13 22:20:46
Subject: Re: wal_buffers, redux

Privacy Policy | About PostgreSQL
Copyright © 1996-2018 The PostgreSQL Global Development Group