The online_analyze module provides set of
features, which immediately update stats after INSERT, UPDATE, DELETE
or SELECT INTO operations applied for affected tables.
To use online_analyze module the first thing you need is to
load shared library:
LOAD 'online_analyze';
Custom variables (default values are shown):
online_analyze.enable = on
Enables online analyze
online_analyze.verbose = on
Execute ANALYZE VERBOSE
online_analyze.scale_factor = 0.1
Fraction of table size to start online analyze (similar to autovacuum_analyze_scale_factor)
online_analyze.threshold = 50
Min number of row updates before online analyze (similar to autovacuum_analyze_threshold)
online_analyze.min_interval = 10000
Minimum time interval between analyze call per table (in milliseconds)
online_analyze.table_type = "all"
Type(s) of tables for online analyze: all, persistent, temporary, none
online_analyze.exclude_tables = ""
List of tables to exclude from online analyze
online_analyze.include_tables = ""
List of tables to include in online analyze (online_analyze.include_tables overrides online_analyze.exclude_tables).
Teodor Sigaev <teodor@sigaev.ru>