On Tue, Jul 26, 2011 at 1:39 PM, A J <[email protected]> wrote: > Does a synchronous_commit force WAL to be committed to disk or does it just > WAIT for WAL to be committed according to WAL's set frequency to write ? > i.e. if I set wal_writer_delay=200ms and set synchronous_commit=on, will > each commit wait for upto 200ms before committing ? >
no, that is synchronous... if you set wal_writer_delay=200ms and set synchronous_commit=off then the commit will not be wal-safe (meaning it won't resist a server crash and you will lose data) for a short period of time (200ms in this example) but you shouldn't be setting synchronous_commit on postgresql.conf normally but from the application -- Jaime Casanova www.2ndQuadrant.com Professional PostgreSQL: Soporte 24x7 y capacitación -- Sent via pgsql-admin mailing list ([email protected]) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin
