On 08/10/2016 07:54 PM, Alexander Korotkov wrote:
> Do I understand right that now async commit right as follows?
> 1) Async transaction confirms commit before flushing WAL.
Yes.
> 2) Other transactions sees effect of async transaction only when its WAL
> flushed.
No. Other transactions also see the effects of the async transaction
before it's flushed.
> 3) In the session which just committed async transaction, effect of this
> transaction is visible immediately (before WAL flushed). Is it true?
Yes. (The same session is not a special case, per previous point. All
sessions see the async transaction as committed, even before it's flushed.)
- Heikki