Re: turning fsync off for WAL

From: Simon Riggs <simon(at)2ndquadrant(dot)com>
To: Ram Ravichandran <ramkaka(at)gmail(dot)com>
Cc: Gregory Stark <stark(at)enterprisedb(dot)com>, pgsql-general(at)postgresql(dot)org
Subject: Re: turning fsync off for WAL
Date: 2008-06-03 07:26:52
Message-ID: 1212478012.4120.429.camel@ebony.site
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Fabien Grumelard 2008-06-03 09:20:22 Offre d'emploi DBA/architecte
Previous Message Rob Johnston 2008-06-03 06:49:29 join ... using ... and - is this expected behaviour?