Re: Add pg_freespacemap extension sql test - Mailing list pgsql-hackers

From Michael Paquier
Subject Re: Add pg_freespacemap extension sql test
Date
Msg-id YkKTtE2/oqxAZtse@paquier.xyz
Whole thread Raw
In response to Re: Add pg_freespacemap extension sql test  (Michael Paquier <michael@paquier.xyz>)
List pgsql-hackers
On Mon, Mar 28, 2022 at 12:12:48PM +0900, Michael Paquier wrote:
> It seems to me here that the snapshot hold by autovacuum during the
> scan of pg_database to find the relations to process is enough to
> prevent the FSM truncation, as the tuples cleaned up by the DELETE
> query still need to be visible.  One simple way to keep this test
> would be a custom configuration file with autovacuum disabled and
> NO_INSTALLCHECK.

Well, done this way.  We already do that in other tests that rely on a
FSM truncation to happen, like 008_fsm_truncation.pl.
--
Michael

Attachment

pgsql-hackers by date:

Previous
From: Michael Paquier
Date:
Subject: Re: Add LZ4 compression in pg_dump
Next
From: Masahiko Sawada
Date:
Subject: Re: Logical replication timeout problem