Search Postgresql Archives

Re: Question about concurrent synchronous and asynchronous commits

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



On Wed, Jan 12, 2011 at 12:03 AM, Dan Birken <birken@xxxxxxxxx> 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.

-- 
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general



[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux