From 8899a2aba92c4a17f422172e7c9dd0e383eefa39 Mon Sep 17 00:00:00 2001 From: Tom Lane Date: Wed, 24 Mar 2004 22:40:29 +0000 Subject: Replace max_expr_depth parameter with a max_stack_depth parameter that is measured in kilobytes and checked against actual physical execution stack depth, as per my proposal of 30-Dec. This gives us a fairly bulletproof defense against crashing due to runaway recursive functions. --- src/backend/utils/misc/postgresql.conf.sample | 5 +++-- 1 file changed, 3 insertions(+), 2 deletions(-) (limited to 'src/backend/utils/misc/postgresql.conf.sample') diff --git a/src/backend/utils/misc/postgresql.conf.sample b/src/backend/utils/misc/postgresql.conf.sample index ff12fbdf829..0001a9ffbb3 100644 --- a/src/backend/utils/misc/postgresql.conf.sample +++ b/src/backend/utils/misc/postgresql.conf.sample @@ -58,7 +58,7 @@ #shared_buffers = 1000 # min 16, at least max_connections*2, 8KB each #work_mem = 1024 # min 64, size in KB #maintenance_work_mem = 16384 # min 1024, size in KB -#debug_shared_buffers = 0 # 0-600 seconds +#max_stack_depth = 2048 # min 100, size in KB #vacuum_cost_page_hit = 1 # 0-10000 credits #vacuum_cost_page_miss = 10 # 0-10000 credits @@ -204,6 +204,8 @@ #log_executor_stats = false #log_statement_stats = false +#debug_shared_buffers = 0 # 0-600 seconds + # - Query/Index Statistics Collector - #stats_start_collector = true @@ -243,7 +245,6 @@ #explain_pretty_print = true #dynamic_library_path = '$libdir' -#max_expr_depth = 10000 # min 10 #--------------------------------------------------------------------------- -- cgit v1.2.3