Postgres Pro
Downloads
Home   >   mailing lists

Re: [GENERAL] Why autvacuum is not started? - Mailing list pgsql-general

From Jeff Janes
Subject Re: [GENERAL] Why autvacuum is not started?
Date
Msg-id CAMkU=1wcRV7MxoQ_rnCae+Epzx62GtZw+q-Kd4bQB3pW=vXZHg@mail.gmail.com
Whole thread Raw
In response to [GENERAL] Why autvacuum is not started?  (Edmundo Robles <edmundo@sw-argos.com>)
List pgsql-general
Tree view
On Mon, Jan 9, 2017 at 8:45 AM, Edmundo Robles <edmundo@sw-argos.com> wrote:
I have running Postgresql  9.4 and... if i have  a  table  with  following  configuration:
autovacuum_vacuum_scale_factor=0.0,
autovacuum_analyze_scale_factor=0.0,
autovacuum_vacuum_threshold=1000,
autovacuum_analyze_threshold=1000,
autovacuum_enabled=true

Why  autovacuum is not started if  the table has more than 1000 inserts???

Inserts do not generate obsolete tuples, and so are not counted against the "vacuum threshold" as described here: 

But inserts can change the data distributions, so do count against "analyze threshold".

Due to index-only-scans and freeze maps, there are reasons to revisit this topic, so that insert only tables do get vacuumed and not just analyzed.  But that re-think has yet to be finished, and certainly won't be back-ported to 9.4.

Cheers,

Jeff

pgsql-general by date:

Previous
From: Israel Brewster
Date:
Subject: Re: [GENERAL] Improve PostGIS performance with 62 million rows?
Next
From: Paul Ramsey
Date:
Subject: Re: [GENERAL] Improve PostGIS performance with 62 million rows?