Re: [GENERAL] Why autvacuum is not started?

Поиск
Список
Период
Сортировка
От Jeff Janes
Тема Re: [GENERAL] Why autvacuum is not started?
Дата
Msg-id CAMkU=1wcRV7MxoQ_rnCae+Epzx62GtZw+q-Kd4bQB3pW=vXZHg@mail.gmail.com
обсуждение исходный текст
Ответ на [GENERAL] Why autvacuum is not started?  (Edmundo Robles <edmundo@sw-argos.com>)
Список pgsql-general
Дерево обсуждения
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 по дате отправления:

Предыдущее
От: Israel Brewster
Дата:
Сообщение: Re: [GENERAL] Improve PostGIS performance with 62 million rows?
Следующее
От: Paul Ramsey
Дата:
Сообщение: Re: [GENERAL] Improve PostGIS performance with 62 million rows?