| 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
| 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 |