Re: use AV worker items infrastructure for GIN pending list's cleanup

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.

https://www.postgresql.org/docs/current/gin-tips.html

> 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
EDB https://www.enterprisedb.com/