Postgres Pro
Downloads
Home   >   mailing lists

Re: Repeatable Read Isolation Level "transaction start time" - Mailing list pgsql-general

From Ron Johnson
Subject Re: Repeatable Read Isolation Level "transaction start time"
Date
Msg-id CANzqJaBZi36rKDn3+R_vgfV6CPOOea8xmomav1zkF8WQwg5+sw@mail.gmail.com
Whole thread Raw
In response to Re: Repeatable Read Isolation Level "transaction start time"  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-general
Tree view
On Wed, Sep 25, 2024 at 1:53 PM Tom Lane <tgl@sss.pgh.pa.us> wrote:
Ron Johnson <ronljohnsonjr@gmail.com> writes:
> But why does "SELECT 1;" need a snapshot?  Heck, why does "SELECT
> <immutable>;" need a snapshot?

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.
 
Perfectly reasonable.

--
Death to <Redacted>, and butter sauce.
Don't boil me, I'm still alive.
<Redacted> crustacean!

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: Repeatable Read Isolation Level "transaction start time"
Next
From: Greg Sabino Mullane
Date:
Subject: Re: Repeatable Read Isolation Level "transaction start time"