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

[Jeff Janes <jeff.janes@xxxxxxxxx>]

On Fri, Aug 28, 2015 at 11:06 AM, Steve Kehlet <steve.kehlet@xxxxxxxxx> wrote:

On Fri, Aug 28, 2015 at 10:42 AM Jeff Janes <jeff.janes@xxxxxxxxx> 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