Movatterモバイル変換

• online_analyze.enable = on

  Enablesonline_analyze.

• online_analyze.verbose = on

  ExecutesANALYZE VERBOSE.

  Note

  Sinceverbose is a reserved SQL key word, this parameter has to be double-quoted when used in SQL queries. For example:

  ALTER SYSTEM SET "online_analyze.verbose" = 'off';

• online_analyze.scale_factor = 0.1

  Fraction of table size to start online analysis (similar toautovacuum_analyze_scale_factor).

• online_analyze.threshold = 50

  Minimum number of row updates before starting online analysis (similar toautovacuum_analyze_threshold).

• online_analyze.min_interval = 10000

  Minimum time interval betweenANALYZE calls per table, in milliseconds.

• online_analyze.table_type = "all"

  Type(s) of tables for online analysis. Possible values are:all,persistent,temporary,none.

• online_analyze.exclude_tables = ""

  List of tables to exclude from online analysis.

• online_analyze.include_tables = ""

  List of tables to include in online analysis (online_analyze.include_tables overridesonline_analyze.exclude_tables).

• online_analyze.local_tracking = off

  Enables per-backend tracking for temporary tables byonline_analyze. When this variable is set tooff,online_analyze uses the default system statistics for temporary tables.

• online_analyze.lower_limit = 0

  Minimum number of rows in a table required to triggeronline_analyze.

• online_analyze.capacity_threshold = 100000

  Maximum number of temporary tables to store in local cache.

      Teodor Sigaev <teodor@sigaev.ru>