synchronous_commit and wal_writer_delay

From: A J <s5aly(at)yahoo(dot)com>
To: PG Admin <pgsql-admin(at)postgresql(dot)org>
Subject: synchronous_commit and wal_writer_delay
Date: 2011-07-26 18:39:22
Message-ID: 1311705562.54342.YahooMailNeo@web120018.mail.ne1.yahoo.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

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 ?

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Jaime Casanova 2011-07-26 22:50:43 Re: synchronous_commit and wal_writer_delay
Previous Message Filippos 2011-07-26 17:46:02 heavy load-high cpu itilization