Re: Regression test postgres_fdw might fail due to autovacuum

From: Melanie Plageman <melanieplageman(at)gmail(dot)com>
To: Alexander Lakhin <exclusion(at)gmail(dot)com>
Cc: pgsql-hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: Regression test postgres_fdw might fail due to autovacuum
Date: 2025-03-23 17:30:07
Message-ID: CAAKRu_bt87GE7povKL_D3ekPcujguWDjCMBWdMr5J4q8vcS+8Q@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On Sun, Mar 23, 2025 at 10:00 AM Alexander Lakhin <exclusion(at)gmail(dot)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

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Melanie Plageman 2025-03-23 17:37:20 Re: Using read_stream in index vacuum
Previous Message Melanie Plageman 2025-03-23 17:27:28 Re: BitmapHeapScan streaming read user and prelim refactoring