Re: Question about concurrent synchronous and asynchronous commits

From: Vick Khera <vivek(at)khera(dot)org>
To: pgsql-general <pgsql-general(at)postgresql(dot)org>
Subject: Re: Question about concurrent synchronous and asynchronous commits
Date: 2011-01-12 20:32:13
Message-ID: AANLkTikVnc50kSAAZSW7geJoXLA0DULic-qNTgftZ-ki@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Wed, Jan 12, 2011 at 12:03 AM, Dan Birken <birken(at)gmail(dot)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.

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message zab08 2011-01-13 01:06:08 Re: My DataBase can't accept conntecion
Previous Message Bill Moran 2011-01-12 15:22:40 Re: My DataBase can't accept conntecion