Re: BRIN autosummarization lacking a snapshot

Поиск
Список
Период
Сортировка
От Michael Paquier
Тема Re: BRIN autosummarization lacking a snapshot
Дата
Msg-id aQmRORhcRHOsGK8h@paquier.xyz
обсуждение исходный текст
Ответ на BRIN autosummarization lacking a snapshot  (Álvaro Herrera <alvherre@kurilemu.de>)
Ответы Re: BRIN autosummarization lacking a snapshot
Список 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

Вложения

В списке pgsql-hackers по дате отправления: