From 81ea27c82c30282dd1fb7d67458aa874b33f6797 Mon Sep 17 00:00:00 2001 From: Xavi Hernandez Date: Fri, 21 Sep 2018 21:51:46 +0200 Subject: Update database profile group Some performance testing has revealed that pgbench performs 3x better when these options are set: performance.client-io-threads=on performance.open-behind=on performance.read-after-open=yes server.event-threads=4 client.event-threads=4 Change-Id: I36ce389f893a8af13aac5f8285104d749b73d098 fixes: bz#1631886 Signed-off-by: Xavi Hernandez --- extras/group-db-workload | 6 +++++- 1 file changed, 5 insertions(+), 1 deletion(-) diff --git a/extras/group-db-workload b/extras/group-db-workload index c9caf21826..9334d6fb94 100644 --- a/extras/group-db-workload +++ b/extras/group-db-workload @@ -1,4 +1,4 @@ -performance.open-behind=off +performance.open-behind=on performance.write-behind=off performance.stat-prefetch=off performance.quick-read=off @@ -6,3 +6,7 @@ performance.strict-o-direct=on performance.read-ahead=off performance.io-cache=off performance.readdir-ahead=off +performance.client-io-threads=on +server.event-threads=4 +client.event-threads=4 +performance.read-after-open=yes -- cgit