Re: VACUUM (INDEX_CLEANUP OFF) and GIN indexes

From: Peter Geoghegan <pg(at)bowt(dot)ie>
To: Christophe Pettus <xof(at)thebuild(dot)com>
Cc: PG-General Mailing List <pgsql-general(at)postgresql(dot)org>
Subject: Re: VACUUM (INDEX_CLEANUP OFF) and GIN indexes
Date: 2023-04-25 16:35:37
Message-ID: CAH2-Wzk3JfYDbAVrrCJe_+GzgBbLBKXuz=f1LXNtx5s8gPt=Kw@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Tue, Apr 25, 2023 at 9:18 AM Christophe Pettus <xof(at)thebuild(dot)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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Christophe Pettus 2023-04-25 16:42:12 Re: VACUUM (INDEX_CLEANUP OFF) and GIN indexes
Previous Message Christophe Pettus 2023-04-25 16:17:32 VACUUM (INDEX_CLEANUP OFF) and GIN indexes