On Wed, Sep 25, 2024 at 4:23 PM Greg Sabino Mullane <htamf...@gmail.com> wrote:
> On Wed, Sep 25, 2024 at 1:53 PM Tom Lane <t...@sss.pgh.pa.us> wrote: > >> Because we're not going to analyze the statement in the amount of depth >> needed to make that distinction before we crank up the >> transactional machinery. If it says SELECT, it gets a snapshot. >> > > Ok, thanks. So to the original poster's point, perhaps the path with the > least side effects / best Principle of Least Surprise (POLS) support is to > start the transaction, and immediately call a "SELECT 1;" or perhaps better > still, a 'SELECT timeofday();' > Since transactions should be "as short as possible, without being too short", how much time is there between when you run "BEGIN;" and the first "work statement"? -- Death to <Redacted>, and butter sauce. Don't boil me, I'm still alive. <Redacted> crustacean!
