Module makes an analyze call immediately after INSERT/UPDATE/DELETE/SELECT INTO
for affected table(s).
-Supported versions of PostgreSQL: 8.4.*, 9.0.*, 9.1.*, 9.2.*, 9.3.*, 9.4*
+Supported versions of PostgreSQL: 8.4.*, 9.0.*, 9.1.*, 9.2.*, 9.3.*, 9.4*, 9.5*,
+ 9.6*
Usage: LOAD 'online_analyze';
online_analyze.enable = on
Enables on-line analyze
+online_analyze.local_tracking = off
+ Per backend tracking for temp tables (do not use system statistic)
+
online_analyze.verbose = on
Execute ANALYZE VERBOSE
online_analyze.min_interval = 10000
Minimum time interval between analyze call per table (in milliseconds)
+online_analyze.lower_limit = 0
+ Min number of rows in table to analyze
+
online_analyze.table_type = "all"
Type(s) of table for online analyze: all, persistent, temporary, none
List of tables which will online analyze
online_analyze.include_tables overwrites online_analyze.exclude_tables.
+online_analyze.capacity_threshold = 100000
+ Maximum number of temporary tables to store in local cache
+
Author: Teodor Sigaev <teodor@sigaev.ru>