On Sat, Sep 19, 2020 at 4:03 AM Tom Lane <t...@sss.pgh.pa.us> wrote: > > Robert Haas <robertmh...@gmail.com> writes: > > Cool, thanks to both of you for looking. Committed. > > Hmph, according to whelk this is worse not better: > > https://buildfarm.postgresql.org/cgi-bin/show_log.pl?nm=whelk&dt=2020-09-18%2017%3A42%3A11 > > I'm at a loss to understand what's going on there. >
I think our assumption that changing the tests to have temp tables will make them safe w.r.t concurrent activity doesn't seem to be correct. We do set OldestXmin for temp tables aggressive enough that it allows us to remove all dead tuples but the test case behavior lies on whether we are able to prune the chain. AFAICS, we are using different cut-offs in heap_page_prune when it is called via lazy_scan_heap. So that seems to be causing both the failures. -- With Regards, Amit Kapila.