Postgres Pro
Downloads
Home   >   mailing lists

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

From Tom Lane
Subject Re: Repeatable Read Isolation Level "transaction start time"
Date
Msg-id 28109.1727286817@sss.pgh.pa.us
Whole thread Raw
In response to Re: Repeatable Read Isolation Level "transaction start time"  (Ron Johnson <ronljohnsonjr@gmail.com>)
Responses Re: Repeatable Read Isolation Level "transaction start time"
Re: Repeatable Read Isolation Level "transaction start time"
List pgsql-general
Tree view 
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.

            regards, tom lane

pgsql-general by date:

Previous
From: Ron Johnson
Date:
Subject: Re: Repeatable Read Isolation Level "transaction start time"
Next
From: Ron Johnson
Date:
Subject: Re: Repeatable Read Isolation Level "transaction start time"