Re: Repeatable Read Isolation Level "transaction start time"

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Ron Johnson <ronljohnsonjr(at)gmail(dot)com>
Cc: "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:53:37
Message-ID: 28109.1727286817@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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.

regards, tom lane

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Ron Johnson 2024-09-25 17:56:51 Re: Repeatable Read Isolation Level "transaction start time"
Previous Message Ron Johnson 2024-09-25 17:50:33 Re: Repeatable Read Isolation Level "transaction start time"