From: | Simon Riggs <simon(dot)riggs(at)enterprisedb(dot)com> |
---|---|
To: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
Cc: | PostgreSQL Hackers <pgsql-hackers(at)postgresql(dot)org> |
Subject: | Re: Pruning never visible changes |
Date: | 2022-09-16 16:56:42 |
Message-ID: | CANbhV-Fm34tB4z5B2EE7Mpna_2TJ82gyD2PRaYsKPrfQGVMsSQ@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
On Fri, 16 Sept 2022 at 15:26, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote:
>
> Simon Riggs <simon(dot)riggs(at)enterprisedb(dot)com> writes:
> > A user asked me whether we prune never visible changes, such as
> > BEGIN;
> > INSERT...
> > UPDATE.. (same row)
> > COMMIT;
>
> Didn't we just have this discussion in another thread?
Not that I was aware of, but it sounds like a different case anyway.
> You cannot
> do that, at least not without checking that the originating
> transaction has no snapshots that could see the older row version.
I'm saying this is possible only AFTER the end of the originating
xact, so there are no issues with additional snapshots.
i.e. the never visible row has to be judged RECENTLY_DEAD before we even check.
--
Simon Riggs http://www.EnterpriseDB.com/
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2022-09-16 17:37:34 | Re: Pruning never visible changes |
Previous Message | Drouvot, Bertrand | 2022-09-16 16:24:07 | Re: Patch proposal: make use of regular expressions for the username in pg_hba.conf |