Re: Repeatable Read Isolation Level "transaction start time"

From: Ron Johnson <ronljohnsonjr(at)gmail(dot)com>
To: "pgsql-generallists(dot)postgresql(dot)org" <pgsql-general(at)lists(dot)postgresql(dot)org>
Subject: Re: Repeatable Read Isolation Level "transaction start time"
Date: 2024-09-25 17:56:51
Message-ID: CANzqJaBZi36rKDn3+R_vgfV6CPOOea8xmomav1zkF8WQwg5+sw@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Wed, Sep 25, 2024 at 1:53 PM Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote:

> Ron Johnson <ronljohnsonjr(at)gmail(dot)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!

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Greg Sabino Mullane 2024-09-25 20:22:31 Re: Repeatable Read Isolation Level "transaction start time"
Previous Message Tom Lane 2024-09-25 17:53:37 Re: Repeatable Read Isolation Level "transaction start time"