Re: BRIN autosummarization lacking a snapshot - Mailing list pgsql-hackers

From Michael Paquier
Subject Re: BRIN autosummarization lacking a snapshot
Date
Msg-id aQmRORhcRHOsGK8h@paquier.xyz
Whole thread Raw
In response to BRIN autosummarization lacking a snapshot  (Álvaro Herrera <alvherre@kurilemu.de>)
Responses Re: BRIN autosummarization lacking a snapshot
List pgsql-hackers
On Mon, Nov 03, 2025 at 12:21:50PM +0100, Alvaro Herrera wrote:
> This patch fixes it.  I haven't given much thought to adding a good way
> to test this yet ...

Spawning an autovacuum worker can feel artistic as we try to make the
tests run fast, but it's not that bad.  The trick is to use an
"autovacuum_naptime = 1".  Then you could either scan the server logs
for some 'autovacuum: processing database "blah"', or just a polling
query based on pg_stat_all_tables.autovacuum_count.  See for example
006_signal_autovacuum.pl.
--
Michael

Attachment

pgsql-hackers by date:

Previous
From: Thomas Munro
Date:
Subject: Re: meson's in-tree libpq header search order vs -Dextra_include_dirs
Next
From: Laurenz Albe
Date:
Subject: Re: ago(interval) → timestamptz