Postgres Pro
Downloads
Home   >   mailing lists

Re: Regression test postgres_fdw might fail due to autovacuum - Mailing list pgsql-hackers

From Melanie Plageman
Subject Re: Regression test postgres_fdw might fail due to autovacuum
Date
Msg-id CAAKRu_bt87GE7povKL_D3ekPcujguWDjCMBWdMr5J4q8vcS+8Q@mail.gmail.com
Whole thread Raw
In response to Regression test postgres_fdw might fail due to autovacuum  (Alexander Lakhin <exclusion@gmail.com>)
List pgsql-hackers
Tree view 
On Sun, Mar 23, 2025 at 10:00 AM Alexander Lakhin <exclusion@gmail.com> wrote:
>
> Interestingly enough, with "log_autovacuum_min_duration = 0" added to
> TEMP_CONFIG, I can't see "automatic vacuum/analyze" messages related
> to ft2/ "S 1"."T 1", so autovacuum somehow affects contents of this table
> indirectly.
>
> With autovacuum = off, all of these fluctuations go away.

If autovacuum is somehow corrupting the table, then isn't there a bug
that needs to be fixed? Also, are you only able to reproduce this on
master?

- Melanie

pgsql-hackers by date:

Previous
From: Melanie Plageman
Date:
Subject: Re: BitmapHeapScan streaming read user and prelim refactoring
Next
From: Melanie Plageman
Date:
Subject: Re: Using read_stream in index vacuum