Re: how to investigate GIN fast updates and cleanup cycles?

From: Jeff Janes <jeff(dot)janes(at)gmail(dot)com>
To: Steve Kehlet <steve(dot)kehlet(at)gmail(dot)com>
Cc: Forums postgresql <pgsql-general(at)postgresql(dot)org>
Subject: Re: how to investigate GIN fast updates and cleanup cycles?
Date: 2015-08-28 18:19:54
Message-ID: CAMkU=1yZKoMgxF4+P3MQBEehn8J=29FMb+FAocuhtTwS2BOUFQ@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Fri, Aug 28, 2015 at 11:06 AM, Steve Kehlet <steve(dot)kehlet(at)gmail(dot)com>
wrote:

> On Fri, Aug 28, 2015 at 10:42 AM Jeff Janes <jeff(dot)janes(at)gmail(dot)com> wrote:
>

>
>
>> Vacuum is overkill (and can be extremely slow to run a large gin index),
>> you just need to get it to autoanalyze by changing the per-table setting of
>> "autovacuum_vacuum_scale_factor" to zero and instead using
>>
>
> Did you mean autovacuum_analyze_scale_factor or does it not matter?
>

Yes, sorry. Those long names make my eyes go bleary.

Cheers,

Jeff

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Jeff Janes 2015-08-28 19:10:25 Re: how to investigate GIN fast updates and cleanup cycles?
Previous Message Tom Lane 2015-08-28 18:18:57 Re: how to investigate GIN fast updates and cleanup cycles?