forked from postgres/postgres
-
Notifications
You must be signed in to change notification settings - Fork 6
Up-to-date mirror of @postgres with Travis-CI / Appveyor integration and PRs
postgrespro/postgres
Folders and files
Name | Name | Last commit message | Last commit date | |
---|---|---|---|---|
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 0
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%