X-Git-Url: http://sigaev.ru/git/gitweb.cgi?p=online_analyze.git;a=blobdiff_plain;f=README.online_analyze;h=d72f17db42414dbf7a2f783ec6289166e9bed663;hp=42c692f1d081875759a1a3283bf49cbbec3dbab1;hb=HEAD;hpb=19a7c6cd289f1977d0781e1e509e89b72e8fb9d6 diff --git a/README.online_analyze b/README.online_analyze index 42c692f..d72f17d 100644 --- 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). -Supported versionsi of PostgreSQL: 8.4.*, 9.0.*, 9.1.*, 9.2.*, 9.3.* +Supported versions of PostgreSQL: 8.4.*, 9.0.*, 9.1.*, 9.2.*, 9.3.*, 9.4*, 9.5*, + 9.6* Usage: LOAD 'online_analyze'; @@ -9,6 +10,9 @@ 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 @@ -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.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 @@ -33,4 +40,7 @@ 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