On Mon, 19 Sept 2022 at 01:16, Greg Stark <st...@mit.edu> wrote: > > On Fri, 16 Sept 2022 at 10:27, Tom Lane <t...@sss.pgh.pa.us> wrote: > > > > Simon Riggs <simon.ri...@enterprisedb.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? > > Well..... not "just" :)
This recent thread [0] mentioned the same, and I mentioned it in [1] too last year. Kind regards, Matthias van de Meent [0] https://www.postgresql.org/message-id/flat/2031521.1663076724%40sss.pgh.pa.us#01542683a64a312e5c21541fecd50e63 Subject: Re: Tuples inserted and deleted by the same transaction Date: 2022-09-13 14:13:44 [1] https://www.postgresql.org/message-id/CAEze2Whjnhg96Wt2-DxtBydhmMDmVm2WfWOX3aGcB2C2Hbry0Q%40mail.gmail.com Subject: Re: pg14b1 stuck in lazy_scan_prune/heap_page_prune of pg_statistic Date: 2021-06-14 09:53:47 (in a thread about a PS comment)
