Re: Question about concurrent synchronous and asynchronous commits - Mailing list pgsql-general

From Vick Khera
Subject Re: Question about concurrent synchronous and asynchronous commits
Date
Msg-id AANLkTikVnc50kSAAZSW7geJoXLA0DULic-qNTgftZ-ki@mail.gmail.com
Whole thread Raw
In response to Question about concurrent synchronous and asynchronous commits  (Dan Birken <birken@gmail.com>)
Responses Re: Question about concurrent synchronous and asynchronous commits  (Dan Birken <birken@gmail.com>)
List pgsql-general
On Wed, Jan 12, 2011 at 12:03 AM, Dan Birken <birken@gmail.com> wrote:
> If I commit asynchronously and then follow that with a synchronous commit,
> does that flush the asynchronous commit as well?

I'm pretty sure it does, because it has to flush the write-ahead log
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.

pgsql-general by date:

Previous
From: Bill Moran
Date:
Subject: Re: My DataBase can't accept conntecion
Next
From: zab08
Date:
Subject: Re: My DataBase can't accept conntecion