Location via proxy:   [ UP ]  
[Report a bug]   [Manage cookies]                
Skip to content

postgrespro/postgres

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

42 Commits
 
 
 
 
 
 
 
 
 
 

Repository files navigation

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*, 9.5*,
		  9.6*

Usage: LOAD 'online_analyze';

Custom variables (defaults values are shown):
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.scale_factor = 0.1
	Fraction of table size to start on-line analyze (similar to
	autovacuum_analyze_scale_factor)

online_analyze.threshold = 50
	Min number of row updates before on-line analyze (similar to
	autovacuum_analyze_threshold)

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

online_analyze.exclude_tables = ""
	List of tables which will not online analyze

online_analyze.include_tables = ""
	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>

About

Up-to-date mirror of @postgres with Travis-CI / Appveyor integration and PRs

Resources

Stars

Watchers

Forks

Packages

No packages published

Languages

  • C 83.3%
  • PLpgSQL 6.0%
  • Perl 2.3%
  • C++ 2.2%
  • TSQL 1.7%
  • Yacc 1.4%
  • Other 3.1%