On Mon, May 17, 2021 at 01:46:37PM +0900, Masahiko Sawada wrote:
> On Mon, Apr 5, 2021 at 3:31 PM Jaime Casanova
> wrote:
> >
> > Hi,
> >
> > 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
> > inde
On Mon, Apr 5, 2021 at 3:31 PM Jaime Casanova
wrote:
>
> Hi,
>
> 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 operati
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 periodi
On Sat, May 15, 2021 at 08:12:51AM +0200, Joel Jacobson wrote:
> On Mon, Apr 5, 2021, at 16:47, Jaime Casanova wrote:
> > On Mon, Apr 05, 2021 at 10:41:22AM -0300, Euler Taveira wrote:
> > > On Mon, Apr 5, 2021, at 3:31 AM, Jaime Casanova wrote:
> > > > When AV worker items where introduced 4 years
On Mon, Apr 5, 2021, at 16:47, Jaime Casanova wrote:
> On Mon, Apr 05, 2021 at 10:41:22AM -0300, Euler Taveira wrote:
> > 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
On Mon, Apr 05, 2021 at 10:41:22AM -0300, Euler Taveira wrote:
> 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 g
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 th
Hi,
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
