projects
/
online_analyze.git
/ blobdiff
commit
grep
author
committer
pickaxe
?
search:
re
summary
|
shortlog
|
log
|
commit
|
commitdiff
|
tree
raw
|
inline
| side by side
Remove _PG_fini Mikhail Litsarev
[online_analyze.git]
/
README.online_analyze
diff --git
a/README.online_analyze
b/README.online_analyze
index
e76b0f5
..
d72f17d
100644
(file)
--- a/
README.online_analyze
+++ b/
README.online_analyze
@@
-1,7
+1,8
@@
Module makes an analyze call immediately after INSERT/UPDATE/DELETE/SELECT INTO
for affected table(s).
Module makes an analyze call immediately after INSERT/UPDATE/DELETE/SELECT INTO
for affected table(s).
-Supported versionsi of PostgreSQL: 8.4.*, 9.0.*, 9.1.*
+Supported versions of PostgreSQL: 8.4.*, 9.0.*, 9.1.*, 9.2.*, 9.3.*, 9.4*, 9.5*,
+ 9.6*
Usage: LOAD 'online_analyze';
Usage: LOAD 'online_analyze';
@@
-9,6
+10,9
@@
Custom variables (defaults values are shown):
online_analyze.enable = on
Enables on-line 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.verbose = on
Execute ANALYZE VERBOSE
@@
-23,6
+27,9
@@
online_analyze.threshold = 50
online_analyze.min_interval = 10000
Minimum time interval between analyze call per table (in milliseconds)
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.table_type = "all"
Type(s) of table for online analyze: all, persistent, temporary, none
@@
-33,4
+40,7
@@
online_analyze.include_tables = ""
List of tables which will online analyze
online_analyze.include_tables overwrites online_analyze.exclude_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>
Author: Teodor Sigaev <teodor@sigaev.ru>