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

From Euler Taveira
Subject Re: use AV worker items infrastructure for GIN pending list's cleanup
Date
Msg-id 8e4b20bc-4b76-4787-92f5-db3dba97a790@www.fastmail.com
Whole thread Raw
In response to use AV worker items infrastructure for GIN pending list's cleanup  (Jaime Casanova <jcasanov@systemguards.com.ec>)
Responses Re: use AV worker items infrastructure for GIN pending list's cleanup
List pgsql-hackers
On Mon, Apr 5, 2021, at 3:31 AM, Jaime Casanova wrote:
When AV worker items where introduced 4 years ago, i was suggested that
it could be used for other things like cleaning the pending list of GIN
index when it reaches gin_pending_list_limit instead of making user
visible operation pay the price.

That never happened though. So, here is a little patch for that.

Should I add an entry for this on next commitfest?
+1. It slipped through the cracks along the years. It is even suggested in the
current docs since the fast update support.


> To avoid fluctuations in observed response time, it's desirable to have
> pending-list cleanup occur in the background (i.e., via autovacuum).

Could you provide a link from the previous discussion?


--
Euler Taveira

pgsql-hackers by date:

Previous
From: Jürgen Purtz
Date:
Subject: Re: Additional Chapter for Tutorial - arch-dev.sgml
Next
From: Amit Langote
Date:
Subject: Re: ModifyTable overheads in generic plans