On Tue, 19 Feb 2008, JP Fletcher wrote:
Shared buffers are set to 5, bgwriter settings are as follows:
bgwriter_delay = 50 # 10-1 milliseconds between
rounds
bgwriter_lru_percent = 20.0 # 0-100% of LRU buffers scanned/round
bgwriter_lru_maxpages = 300
On Feb 19, 2008, at 3:58 PM, Dan Langille wrote:
Erik Jones wrote:
On Feb 15, 2008, at 3:55 PM, Dan Langille wrote:
We're using PostgreSQL 8.1.11 on AIX 5.3 and we've been doing
some playing around
with various settings. So far, we've (I say we, but it's another
guy doing the work) found
Erik Jones wrote:
On Feb 15, 2008, at 3:55 PM, Dan Langille wrote:
We're using PostgreSQL 8.1.11 on AIX 5.3 and we've been doing some
playing around
with various settings. So far, we've (I say we, but it's another guy
doing the work) found
that open_datasync seems better than fsync. By how
Dan Langille wrote:
Begin forwarded message:
From: "Joshua D. Drake" <[EMAIL PROTECTED]>
Date: February 15, 2008 5:04:53 PM EST
To: Dan Langille <[EMAIL PROTECTED]>
Cc: pgsql-performance@postgresql.org
Subject: Re: [PERFORM] wal_sync_methods for AIX
-BEGIN PGP SI
On Feb 15, 2008, at 3:55 PM, Dan Langille wrote:
We're using PostgreSQL 8.1.11 on AIX 5.3 and we've been doing some
playing around
with various settings. So far, we've (I say we, but it's another
guy doing the work) found
that open_datasync seems better than fsync. By how much, we have
n
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On Fri, 15 Feb 2008 16:55:45 -0500
Dan Langille <[EMAIL PROTECTED]> wrote:
> Our tests have been on a p550 connected to DS6800 array using pgbench.
>
> One nasty behaviour we have seen is long running commits. Initial
> thoughts connected
> them wi
We're using PostgreSQL 8.1.11 on AIX 5.3 and we've been doing some
playing around
with various settings. So far, we've (I say we, but it's another guy
doing the work) found
that open_datasync seems better than fsync. By how much, we have not
yet determined,
but initial observations are pro