Re: Repeatable Read Isolation Level "transaction start time"

Поиск
Список
Период
Сортировка
От Ron Johnson
Тема Re: Repeatable Read Isolation Level "transaction start time"
Дата
Msg-id CANzqJaBZi36rKDn3+R_vgfV6CPOOea8xmomav1zkF8WQwg5+sw@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Repeatable Read Isolation Level "transaction start time"  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-general
Дерево обсуждения
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 по дате отправления: