Re: asynchronous commit risk window is overly optimistic

2019-04-09 Thread Bruce Momjian
On Wed, Mar 20, 2019 at 02:50:21PM -0400, Jeff Janes wrote: > https://www.postgresql.org/docs/current/wal-async-commit.html: > > "If the database crashes during the risk window between an asynchronous commit > and the writing of the transaction's WAL records, then changes made during > that > tra

asynchronous commit risk window is overly optimistic

2019-03-20 Thread Jeff Janes
https://www.postgresql.org/docs/current/wal-async-commit.html: "If the database crashes during the risk window between an asynchronous commit and the writing of the transaction's WAL records, then changes made during that transaction will be lost. The duration of the risk window is limited because