Обсуждение: asynchronous commit

Поиск
Список
Период
Сортировка

asynchronous commit

От
yamt@mwd.biglobe.ne.jp (YAMAMOTO Takashi)
Дата:
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