On 25 Sep 2015, at 1:27am, Allen <allenpmd at gmail.com> wrote: >> Why on earth are you using BEGIN EXCLUSIVE? > > If WAL works "as advertised", I might as well go straight to EXCLUSIVE so I > don't have to later escalate the lock from RESERVED to EXCLUSIVE. And it > does work just fine, once I turned off the shared cache mode.
You don't have to escalate at all. That happens automatically. The problem with going to EXCLUSIVE manually is that you lock out other connections for longer than necessary. Simon.
