diff options
| author | Joachim Tingvold <joachim@tingvold.com> | 2016-03-29 22:17:31 +0200 |
|---|---|---|
| committer | root <root@wat.gathering.org> | 2016-03-29 22:17:31 +0200 |
| commit | c3cfa21acad31c22841bfcb22a6618050b39354c (patch) | |
| tree | f624f46ae8cdc2a0ec017ba3414d2ba37a4cea65 | |
| parent | 9f8e1eed8d695c2980b05d9310a34db19edba69f (diff) | |
Postgres-tweaks.
| -rw-r--r-- | nms/postgresql.conf | 4 |
1 files 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 |