Re: Question about MVCC caveats

From: Laurenz Albe <laurenz(dot)albe(at)cybertec(dot)at>
To: Jim Nasby <jnasby(at)upgrade(dot)com>, pgsql-general(at)postgresql(dot)org
Subject: Re: Question about MVCC caveats
Date: 2025-11-13 22:10:18
Message-ID: 224564d6e38cef32d7b19e90bb15080dbaa79ea0.camel@cybertec.at
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Thu, 2025-11-13 at 13:30 -0600, Jim Nasby wrote:
> At [1], the docs state that table rewrite ALTERs result in the relation appearing
> empty after the ALTER if another transaction had already taken a snapshot before
> the ALTER. A simple test with a repeatable read (or serializable) transaction
> confirms this... but is there any other situation where a snapshot would be taken?

Snapshots are taken at the start of a statement (or, with REPEATABLE READ and
SERIALIZABLE) at the beginning of the first statement in the transaction.

What do you mean with an "other" situation?

Yours,
Laurenz Albe

In response to

Browse pgsql-general by date

  From Date Subject
Next Message KK CHN 2025-11-14 08:32:38 Pgbackrest info output interpretation
Previous Message Jim Nasby 2025-11-13 19:30:44 Question about MVCC caveats