asynchronous commit - Mailing list pgsql-novice

From yamt@mwd.biglobe.ne.jp (YAMAMOTO Takashi)
Subject asynchronous commit
Date
Msg-id 20110205052023.E4C8119CEA9@mail.netbsd.org
Whole thread Raw
List pgsql-novice
hi,

is there a way for an application to know if an asynchronously
committed transaction is actually committed or not?
i want to issue some asynchronous transactions and, at some point later,
ensure that they are committed.
if my reading of the code is correct, an empty synchronous commit
(BEGIN;SET LOCAL SYNCHRONOUS_COMMIT TO ON;COMMIT;) doesn't flush
the log, right?  if so, is there any good way to force a log flush?
a CHECKPOINT seems a bit overkill for my purpose.

YAMAMOTO Takashi

pgsql-novice by date:

Previous
From: Tom Lane
Date:
Subject: Re: "-t template0" in createdb
Next
From: JORGE MALDONADO
Date:
Subject: Backing up several PostgreSQL databases