Wiki / Configuration Parameters
autovacuum_analyze_scale_factor
Specifies a fraction of the table size to add to autovacuum_analyze_threshold when deciding whether to trigger an ANALYZE. The default is 0.1 (10% of table size). This parameter can only be set in the postgresql.conf file or on the server command line; but the setting can be overridden for individual tables by changing table storage parameters.
English manual coverage begins with PostgreSQL 7.4. Source history and runtime observations have their own recorded version boundaries.
Reading PG 18·Select a recorded version
- boot val
- 0.1
- category
- Vacuuming / Automatic Vacuuming
- context
- sighup
- doc same as
- Unknown
- documented
- true
- enumvals
- Unknown
- extra desc
- Unknown
- lang
- en
- max val
- 100
- metadata version
- 18
- min val
- 0
- name
- autovacuum_analyze_scale_factor
- short desc
- Number of tuple inserts, updates, or deletes prior to analyze as a fraction of reltuples.
- source
- pg-settings-source-snapshot
- unit
- Unknown
- vartype
- real
Definition PG 18
Specifies a fraction of the table size to add to
autovacuum_analyze_threshold
when deciding whether to trigger an ANALYZE.
The default is 0.1 (10% of table size).
This parameter can only be set in the postgresql.conf
file or on the server command line;
but the setting can be overridden for individual tables by
changing table storage parameters.
Compare versions
Complete source facts
doc html
<p>
Specifies a fraction of the table size to add to
<code class="varname">autovacuum_analyze_threshold</code>
when deciding whether to trigger an <code class="command">ANALYZE</code>.
The default is <code class="literal">0.1</code> (10% of table size).
This parameter can only be set in the <code class="filename">postgresql.conf</code>
file or on the server command line;
but the setting can be overridden for individual tables by
changing table storage parameters.
</p>documentation revision
{"inputs":[{"file":"runtime-config-vacuum.html","kind":"same-version-reviewed-manual","locale":"en","sha256":"599d3819c5fa60f160ba633df604ee9afd85549ffad2ae2fb0c3132a00d47417","version":"18.7"},{"file":"runtime-config-vacuum.html","kind":"same-version-reviewed-manual","locale":"zh-Hans","sha256":"b835e4b6c446cfdaf673750aba29ba28fc55ef6cc0c531558c1e394fdc05a140","version":"18.7"}],"release":"18.7","runtime_remeasured":false,"source_revision":"pgdoc:b9f0e7232f60f380d642ac9b99226606c254b552"}Source references
Full definition and evidence JSON
Definition sources
center · PostgreSQL 18 · wiki-repair-20261023:0944df4d68b2283e68f62581218f48e0f35d49c00ab393200c4849db2d0ac5fd
Text language: en · wiki-repair-20261023:0944df4d68b2283e68f62581218f48e0f35d49c00ab393200c4849db2d0ac5fd