Re: use AV worker items infrastructure for GIN pending list's cleanup
От
Euler Taveira
Тема
Re: use AV worker items infrastructure for GIN pending list's cleanup
Дата
Msg-id
8e4b20bc-4b76-4787-92f5-db3dba97a790@www.fastmail.com
Ответ на
use AV worker items infrastructure for GIN pending list's cleanup (Jaime Casanova)
Список
Дерево обсуждения
use AV worker items infrastructure for GIN pending list's cleanup Jaime Casanova <jcasanov@systemguards.com.ec>
Re: use AV worker items infrastructure for GIN pending list's cleanup "Euler Taveira" <euler@eulerto.com>
Re: use AV worker items infrastructure for GIN pending list's cleanup Jaime Casanova <jcasanov@systemguards.com.ec>
Re: use AV worker items infrastructure for GIN pending list's cleanup "Joel Jacobson" <joel@compiler.org>
Re: use AV worker items infrastructure for GIN pending list's cleanup Jaime Casanova <jcasanov@systemguards.com.ec>
Re: use AV worker items infrastructure for GIN pending list's cleanup "Joel Jacobson" <joel@compiler.org>
Re: use AV worker items infrastructure for GIN pending list's cleanup Masahiko Sawada <sawada.mshk@gmail.com>
Re: use AV worker items infrastructure for GIN pending list's cleanup Jaime Casanova <jcasanov@systemguards.com.ec>
On Mon, Apr 5, 2021, at 3:31 AM, Jaime Casanova wrote:
When AV worker items where introduced 4 years ago, i was suggested thatit could be used for other things like cleaning the pending list of GINindex when it reaches gin_pending_list_limit instead of making uservisible 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?
В списке pgsql-hackers по дате отправления
