Amit Kapila <amit.kapil...@gmail.com> writes: > On Sun, Sep 20, 2020 at 10:43 PM Tom Lane <t...@sss.pgh.pa.us> wrote: >> AFAICS, there is no chance of the existing pg_surgery regression test >> being fully stable if we don't fix both things.
> What if ensure that it runs with autovacuum = off and there is no > parallel test running? I am not sure about the second part but if we > can do that then the test will be probably stable. Then it'll not be usable under "make installcheck", which is not very nice. It's also arguable that you aren't testing pg_surgery under real-world conditions if you do it like that. Moreover, I think that both of these points need to be addressed anyway, as they represent bugs that are reachable independently of pg_surgery. Admittedly, we do not have a test case that proves that the inconsistency between pruneheap and vacuum has any bad effects in the absence of a7212be8b. But do you really want to bet that there are none? regards, tom lane