From: | Erik Jones <erik(at)myemma(dot)com> |
---|---|
To: | Dan Langille <dan(at)langille(dot)org> |
Cc: | pgsql-performance(at)postgresql(dot)org |
Subject: | Re: wal_sync_methods for AIX |
Date: | 2008-02-19 22:09:41 |
Message-ID: | 402844F1-5FB7-4705-A9A6-DF7C76A8EB24@myemma.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-performance |
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
>>> that open_datasync seems better than fsync. By how much, we have
>>> not yet determined,
>>> but initial observations are promising.
>> Here's a good explanation (by the Greg Smith) on the different
>> sync methods. It basically says that if you have open_datasync
>> available, it'll probably beat everything else.
>
> Where is that explanation?
Sorry, did I leave off the link? http://www.westnet.com/~gsmith/
content/postgresql/TuningPGWAL.htm
Erik Jones
DBA | Emma®
erik(at)myemma(dot)com
800.595.4401 or 615.292.5888
615.292.0777 (fax)
Emma helps organizations everywhere communicate & market in style.
Visit us online at http://www.myemma.com
From | Date | Subject | |
---|---|---|---|
Next Message | Greg Smith | 2008-02-19 22:53:45 | Re: 7 hrs for a pg_restore? |
Previous Message | Dan Langille | 2008-02-19 21:58:19 | Re: wal_sync_methods for AIX |