From 5b4de577c03e7efefe64b627a2ee9d08a7a77956 Mon Sep 17 00:00:00 2001 From: Teodor Sigaev Date: Thu, 8 Oct 2026 12:39:22 +0300 Subject: [PATCH] Change default GUC values Autovacuum collects statistics well enough for persistent tables, so the default table_type should be 'temporary'. Rimma Tolkacheva --- README.online_analyze | 4 ++-- online_analyze.c | 4 ++-- 2 files changed, 4 insertions(+), 4 deletions(-) diff --git a/README.online_analyze b/README.online_analyze index d72f17d..7d2dbe4 100644 --- a/README.online_analyze +++ b/README.online_analyze @@ -7,7 +7,7 @@ Supported versions of PostgreSQL: 8.4.*, 9.0.*, 9.1.*, 9.2.*, 9.3.*, 9.4*, 9.5*, Usage: LOAD 'online_analyze'; Custom variables (defaults values are shown): -online_analyze.enable = on +online_analyze.enable = off Enables on-line analyze online_analyze.local_tracking = off @@ -30,7 +30,7 @@ online_analyze.min_interval = 10000 online_analyze.lower_limit = 0 Min number of rows in table to analyze -online_analyze.table_type = "all" +online_analyze.table_type = "temporary" Type(s) of table for online analyze: all, persistent, temporary, none online_analyze.exclude_tables = "" diff --git a/online_analyze.c b/online_analyze.c index ba967af..22aa0fe 100644 --- a/online_analyze.c +++ b/online_analyze.c @@ -67,7 +67,7 @@ PG_MODULE_MAGIC; #endif -static bool online_analyze_enable = true; +static bool online_analyze_enable = false; static bool online_analyze_local_tracking = false; static bool online_analyze_verbose = true; static double online_analyze_scale_factor = 0.1; @@ -116,7 +116,7 @@ static const struct config_enum_entry online_analyze_table_type_options[] = {NULL, 0, false}, }; -static int online_analyze_table_type = (int)OATT_ALL; +static int online_analyze_table_type = (int)OATT_TEMPORARY; typedef struct TableList { int nTables; -- 2.55.0