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

From Greg Sabino Mullane
Subject Re: Repeatable Read Isolation Level "transaction start time"
Date
Msg-id CAKAnmmL05Lt89EOnMW111qdUOau+dYG7u8ff5o+ckKKohnNwGg@mail.gmail.com
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
Since transactions should be "as short as possible, without being too short", how much time is there between when you run "BEGIN;" and the first "work statement"?

I don't know that it really matters. For something automated, it would be a few milliseconds. Either way, I'm sure most people/apps already think of the initial 'BEGIN ...' as the start of the transaction, and act accordingly.

Maybe long-term something like

BEGIN   ISOLATION MODE REPEATABLE READ   SNAPSHOT NOW;

could be useful.

Cheers,
Greg


pgsql-general by date:

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