[HACKERS] snapshots in analyze

Hi, I previously complained about analyze keeping a snapshot while running in: http://archives.postgresql.org/message-id/20141018174909.GA5790%40alap3.anarazel.de since then I've been bitten by that, and I've seen other people being bitten by it. on a scale 400 database (so analyze actually

Re: [HACKERS] snapshots in analyze

Andres Freund writes: > Another angle would be trying to reduce the effects of longrunning > transaction. Right now holding a snapshot open for 100 seconds results > in profiles like this: ... > which is pretty extreme. It's not such a seldom thing to hold a snapshot > (e.g.

Re: [HACKERS] snapshots in analyze

On 2015-10-31 12:52:44 -0400, Tom Lane wrote: > Andres Freund writes: > > Another angle would be trying to reduce the effects of longrunning > > transaction. Right now holding a snapshot open for 100 seconds results > > in profiles like this: ... > > which is pretty extreme.