From a9fd91c71bf92d7e0aa8e71bd8dfc5d8e69400f5 Mon Sep 17 00:00:00 2001 From: Guillaume Pellerin Date: Tue, 3 Aug 2021 01:27:17 +0200 Subject: [PATCH] increase postgres workers --- etc/postgresql.conf | 6 +++--- 1 file changed, 3 insertions(+), 3 deletions(-) diff --git a/etc/postgresql.conf b/etc/postgresql.conf index e9fc669f..72618547 100644 --- a/etc/postgresql.conf +++ b/etc/postgresql.conf @@ -174,13 +174,13 @@ dynamic_shared_memory_type = posix # the default is the first option # - Asynchronous Behavior - -effective_io_concurrency = 200 # 1-1000; 0 disables prefetching +effective_io_concurrency = 512 # 1-1000; 0 disables prefetching #maintenance_io_concurrency = 10 # 1-1000; 0 disables prefetching -max_worker_processes = 16 # (change requires restart) +max_worker_processes = 32 # (change requires restart) max_parallel_maintenance_workers = 4 # taken from max_parallel_workers max_parallel_workers_per_gather = 4 # taken from max_parallel_workers #parallel_leader_participation = on -max_parallel_workers = 16 # maximum number of max_worker_processes that +max_parallel_workers = 32 # maximum number of max_worker_processes that # can be used in parallel operations #old_snapshot_threshold = -1 # 1min-60d; -1 disables; 0 is immediate # (change requires restart) -- 2.39.5