Postgres Pro
Downloads
Home   >   mailing lists

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

From Peter Geoghegan
Subject Re: VACUUM (INDEX_CLEANUP OFF) and GIN indexes
Date
Msg-id CAH2-Wzk3JfYDbAVrrCJe_+GzgBbLBKXuz=f1LXNtx5s8gPt=Kw@mail.gmail.com
Whole thread Raw
In response to VACUUM (INDEX_CLEANUP OFF) and GIN indexes  (Christophe Pettus <xof@thebuild.com>)
Responses Re: VACUUM (INDEX_CLEANUP OFF) and GIN indexes
List pgsql-general
Tree view 
On Tue, Apr 25, 2023 at 9:18 AM Christophe Pettus <xof@thebuild.com> wrote:
> Does VACUUM (INDEX_CLEANUP OFF) flush the pending list for GIN indexes, or is that skipped as well?

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.

The ANALYZE pending list cleanup path has some problems:

https://postgr.es/m/CAH2-WzkjrK556enVtFLmyXEdw91xGuwiyZVep2kp5yQT_-3JDg@mail.gmail.com


--
Peter Geoghegan

pgsql-general by date:

Previous
From: Christophe Pettus
Date:
Subject: VACUUM (INDEX_CLEANUP OFF) and GIN indexes
Next
From: Christophe Pettus
Date:
Subject: Re: VACUUM (INDEX_CLEANUP OFF) and GIN indexes