Postgres Pro
Downloads
Home   >   mailing lists

Re: how to investigate GIN fast updates and cleanup cycles? - Mailing list pgsql-general

From Jeff Janes
Subject Re: how to investigate GIN fast updates and cleanup cycles?
Date
Msg-id CAMkU=1yZKoMgxF4+P3MQBEehn8J=29FMb+FAocuhtTwS2BOUFQ@mail.gmail.com
Whole thread Raw
In response to Re: how to investigate GIN fast updates and cleanup cycles?  (Steve Kehlet <steve.kehlet@gmail.com>)
List pgsql-general
Tree view
On Fri, Aug 28, 2015 at 11:06 AM, Steve Kehlet <steve.kehlet@gmail.com> wrote:
On Fri, Aug 28, 2015 at 10:42 AM Jeff Janes <jeff.janes@gmail.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

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: how to investigate GIN fast updates and cleanup cycles?
Next
From: Dominik Czarnota
Date:
Subject: Re: Does PLPythonU support COPY table FROM string?