Postgres Pro
Downloads
Home   >   mailing lists

synchronous_commit and wal_writer_delay - Mailing list pgsql-admin

From A J
Subject synchronous_commit and wal_writer_delay
Date
Msg-id 1311705562.54342.YahooMailNeo@web120018.mail.ne1.yahoo.com
Whole thread Raw
Responses Re: synchronous_commit and wal_writer_delay
List pgsql-admin
Tree view
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 ?

pgsql-admin by date:

Previous
From: Filippos
Date:
Subject: heavy load-high cpu itilization
Next
From: Jaime Casanova
Date:
Subject: Re: synchronous_commit and wal_writer_delay