Re: Commit(?) overhead

2019-04-10 Thread Duncan Kinnear
ng as that on my local machine. The option appears to be relatively safe, but my machine is just a dev test machine anyway. Regards, Duncan Kinnear

Re: Commit(?) overhead

2019-04-09 Thread Duncan Kinnear
- On 5 Apr, 2019, at 4:14 AM, Jeff Janes wrote: > On Thu, Apr 4, 2019 at 3:42 AM Duncan Kinnear < [ > mailto:duncan.kinn...@mccarthy.co.nz | duncan.kinn...@mccarthy.co.nz ] > > wrote: >> the EXPLAIN (ANALYSE, TIMING TRUE) of this query gives: >> Update on next

Commit(?) overhead

2019-04-04 Thread Duncan Kinnear
vers are experiencing. But I have no idea where to look to try and find where this time is being spent. Note that the schemas of the databases on the 3 servers involved are virtually identical. The schema for this table is exactly the same. Hoping that someone can give me an idea about where to g