Re: [PERFORM] Strange query stalls on replica in 9.3.9

2015-08-14 Thread Jeff Janes
On Fri, Aug 14, 2015 at 9:34 AM, Josh Berkus wrote: > > On 08/13/2015 01:59 PM, Jeff Janes wrote: execute on the > > > Once the commit of the whole-table update has replayed, the problem > > should go way instantly because at that point each backend doing the > > seqscan will find the the transac

Re: [PERFORM] Strange query stalls on replica in 9.3.9

2015-08-14 Thread Josh Berkus
On 08/13/2015 01:24 PM, Kevin Grittner wrote: >> Thing is, the update all rows only takes 2.5 seconds to execute on the >> master. So even if the update is blocking the seq scans on the replica >> (and I can't see why it would), it should only block them for < 3 seconds. > > Visibility hinting and