Re: VACUUM (INDEX_CLEANUP OFF) and GIN indexes - Mailing list pgsql-general

From Christophe Pettus
Subject Re: VACUUM (INDEX_CLEANUP OFF) and GIN indexes
Date
Msg-id 340387D3-197E-441B-AAB9-26B9B9656B1A@thebuild.com
Whole thread Raw
In response to Re: VACUUM (INDEX_CLEANUP OFF) and GIN indexes  (Peter Geoghegan <pg@bowt.ie>)
List pgsql-general

> On Apr 25, 2023, at 09:35, Peter Geoghegan <pg@bowt.ie> wrote:
>
> It's skipped by VACUUM, but not by ANALYZE. So if you're using the
> reloption version of index_cleanup=off, it isn't necessarily going to
> stop autovacuum/autoanalyze from doing pending list cleanup.

Ugh, thanks.  I wasn't aware that it was flushed by ANALYZE as well.  The current algorithm for pending list flush is
kindof problematic in itself, because it relies on the highly optimistic assumption that the pending list won't grow
verymuch while the list is being flushed. 


pgsql-general by date:

Previous
From: Peter Geoghegan
Date:
Subject: Re: VACUUM (INDEX_CLEANUP OFF) and GIN indexes
Next
From: "Peter J. Holzer"
Date:
Subject: Re: DBD::Pg (version 3.16.3) returns EMPTY char columns as 'undef'