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

Re: wal_buffers, redux

From: Andres Freund <andres(at)anarazel(dot)de>
To: pgsql-hackers(at)postgresql(dot)org
Cc: Robert Haas <robertmhaas(at)gmail(dot)com>, Jeff Janes <jeff(dot)janes(at)gmail(dot)com>
Subject: Re: wal_buffers, redux
Date: 2012-03-13 08:55:04
Message-ID: 201203130955.05030.andres@anarazel.de (view raw or flat)
Thread:
Lists: pgsql-hackers
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".

Whats the filesystem + options on this?

Andres

In response to

Responses

pgsql-hackers by date

Next:From: Etsuro FujitaDate: 2012-03-13 09:13:08
Subject: Re: NOT NULL violation error handling in file_fdw
Previous:From: Andres FreundDate: 2012-03-13 08:42:03
Subject: Re: initdb and fsync

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