Re: turning fsync off for WAL - Mailing list pgsql-general

From Simon Riggs
Subject Re: turning fsync off for WAL
Date
Msg-id 1212478012.4120.429.camel@ebony.site
Whole thread Raw
In response to Re: turning fsync off for WAL  ("Ram Ravichandran" <ramkaka@gmail.com>)
List pgsql-general
On Tue, 2008-06-03 at 00:04 -0400, Ram Ravichandran wrote:

> This seems like a much better idea. So, I should
> a) disable synchronous_commit
> b) set wal_writer_delay to say 1 minute (and leave fsync on)
> c) symlink pg_xlog to the PersistentFS on S3.
>

a) sounds good. b) has a max setting of 10 seconds, which I think is a
realistic maximum in this case also.

--
 Simon Riggs           www.2ndQuadrant.com
 PostgreSQL Training, Services and Support


pgsql-general by date:

Previous
From: "Kimball Johnson"
Date:
Subject: make rows unique across db's without UUIP on windows?
Next
From: Fabien Grumelard
Date:
Subject: Offre d'emploi DBA/architecte