autovacuum_analyze_scale_factor and autovacuum_analyze_scale_factor

From: Henry Francisco Garcia Cortez <garcortez(at)gmail(dot)com>
To: pgsql-admin(at)postgresql(dot)org
Subject: autovacuum_analyze_scale_factor and autovacuum_analyze_scale_factor
Date: 2021-01-06 17:05:41
Message-ID: CAJP2v3G0S4pRGKDb6vNZuiU+N6TFhXXruLCQeTyJEBAV42CJ3g@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Hi community I have a question why settings default postgresql has
autovacuum_vacuum_scale_factor in 0.2 is higher than
autovacuum_analyze_scale_factor 0.1, so If want to tune these parameters, I
always must leave autovacuum_vacuum_scale_factor higher than
autovacuum_analyze_scale_factor, for instance I wanted to leave
autovacuum_vacuum_scale_factor in 0.002 and autovacuum_analyze_scale_factor
in 0.001

--
Ing. Henry G. Cortez

<https://www.avast.com/sig-email?utm_medium=email&utm_source=link&utm_campaign=sig-email&utm_content=webmail>
Libre
de virus. www.avast.com
<https://www.avast.com/sig-email?utm_medium=email&utm_source=link&utm_campaign=sig-email&utm_content=webmail>
<#DAB4FAD8-2DD7-40BB-A1B8-4E2AA1F9FDF2>

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Laurenz Albe 2021-01-07 01:53:31 Re: autovacuum_analyze_scale_factor and autovacuum_analyze_scale_factor
Previous Message Scott Ribe 2021-01-06 16:41:40 quick q re migration, index, stats