I notice on the documentation page about Asynchronous Commit (
http://www.postgresql.org/docs/8.3/static/wal-async-commit.html*)*, it says
the follow "The user can select the commit mode of each transaction, so that
it is possible to have both synchronous and asynchronous commit transactions
running concurrently". Now out of curiously, I have a couple questions
about the details of this.
If I commit asynchronously and then follow that with a synchronous commit,
does that flush the asynchronous commit as well?
Is the WAL strictly linear in that commit order must always replay back in
the order that transactions return on the server, regardless of whether they
are asynchronous or synchronous?
Thanks,
Dan