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