Re: use AV worker items infrastructure for GIN pending list's cleanup - Mailing list pgsql-hackers

From Joel Jacobson
Subject Re: use AV worker items infrastructure for GIN pending list's cleanup
Date
Msg-id 39f4f03b-4b3c-4335-a424-8079cd2f7b99@www.fastmail.com
Whole thread Raw
In response to Re: use AV worker items infrastructure for GIN pending list's cleanup  (Jaime Casanova <jcasanov@systemguards.com.ec>)
List pgsql-hackers
On Sat, May 15, 2021, at 08:42, Jaime Casanova wrote:
A customer here has 20+ GIN indexes in a big heavily used table and
every time one of the indexes reaches gin_pending_list_limit (because of
an insert or update) a user feels the impact.

So, currently we have a cronjob running periodically and checking
pending list sizes to process the index before the limit get fired by an
user operation. While the index still is processed and locked the fact
that doesn't happen in the user face make the process less notorious and
in the mind of users faster.

This will provide the same facility, the process will happen "in the
background".

Sounds like a great improvement, many thanks.

/Joel

pgsql-hackers by date:

Previous
From: Jaime Casanova
Date:
Subject: Re: use AV worker items infrastructure for GIN pending list's cleanup
Next
From: Julien Rouhaud
Date:
Subject: Re: compute_query_id and pg_stat_statements