From c3cfa21acad31c22841bfcb22a6618050b39354c Mon Sep 17 00:00:00 2001 From: Joachim Tingvold Date: Tue, 29 Mar 2016 22:17:31 +0200 Subject: Postgres-tweaks. --- nms/postgresql.conf | 4 ++-- 1 file changed, 2 insertions(+), 2 deletions(-) diff --git a/nms/postgresql.conf b/nms/postgresql.conf index dee1129..5c45d68 100644 --- a/nms/postgresql.conf +++ b/nms/postgresql.conf @@ -145,7 +145,7 @@ dynamic_shared_memory_type = posix # the default is the first option #max_files_per_process = 1000 # min 25 # (change requires restart) -#shared_preload_libraries = '' # (change requires restart) +shared_preload_libraries = '' # (change requires restart) # - Cost-Based Vacuum Delay - @@ -393,7 +393,7 @@ wal_level = archive # minimal, archive, hot_standby, or logical # fatal # panic (effectively off) -#log_min_duration_statement = -1 # -1 is disabled, 0 logs all statements +log_min_duration_statement = 2000 # -1 is disabled, 0 logs all statements # and their durations, > 0 logs only # statements running at least this number # of milliseconds -- cgit v1.2.3