Re: Something is broken about connection startup - Mailing list pgsql-hackers

From Tom Lane
Subject Re: Something is broken about connection startup
Date
Msg-id 30195.1479137192@sss.pgh.pa.us
Whole thread Raw
In response to Re: Something is broken about connection startup  (Robert Haas <robertmhaas@gmail.com>)
Responses Re: Something is broken about connection startup  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-hackers
Robert Haas <robertmhaas@gmail.com> writes:
> I assume you're going to back-patch this, and the consequences of
> failing to reset it before going idle could easily be vastly worse
> than the problem you're trying to fix.  So I'd rather not make
> assumptions like "the client will probably never sleep between Bind
> and Execute".  I bet that's actually false, and I certainly wouldn't
> want to bet the farm on it being true.

No, I'm not at all proposing to assume that.  But I may be willing to
assume that "we don't hold a CatalogSnapshot between Bind and Execute
unless we're also holding a transaction snapshot".  I need to do a bit
more research to see if that's actually true, though.
        regards, tom lane



pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: Pinning a buffer in TupleTableSlot is unnecessary
Next
From: Robert Haas
Date:
Subject: Re: [bug fix] Cascading standby cannot catch up and get stuck emitting the same message repeatedly