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 -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
