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/
