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 -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general