When you begin a transaction, all your changes write to the in-memory WAL buffer, and that buffer flushes to disk when:
a) Somebody commits a synchronous transaction
b) The WAL buffer runs out of space
Please correct me if I'm wrong.
-Dan
On Wed, Jan 12, 2011 at 12:32 PM, Vick Khera <vivek@xxxxxxxxx> wrote:
On Wed, Jan 12, 2011 at 12:03 AM, Dan Birken <birken@xxxxxxxxx> wrote:I'm pretty sure it does, because it has to flush the write-ahead log
> If I commit asynchronously and then follow that with a synchronous commit,
> does that flush the asynchronous commit as well?
to disk, and there's only one. You can think of it as getting the
flush for free from the first transaction, since the single flush
covered the requirements of both transactions.
--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
