From f47383d694d60342e6f5485fea85e7b61d4a988a Mon Sep 17 00:00:00 2001 From: Xiubo Li Date: Tue, 5 Sep 2023 08:50:37 +0800 Subject: [PATCH] qa: descrease pgbench scale factor to 32 for postgresql database test The scale factor will depend on the node's performance and disk sizes being used to run the test, and 500 seems too large here as a common test case without knowing the nodes' configuration. We should just follow the white-book: https://github.com/ApsaraDB/PolarDB-for-PostgreSQL/blob/distributed/doc/polardb/benchmark.md Fixes: https://tracker.ceph.com/issues/62700 Signed-off-by: Xiubo Li (cherry picked from commit 497f951c0ddcb4be3921ef887f866eb534258537) --- qa/suites/fs/workload/tasks/5-workunit/postgres.yaml | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) diff --git a/qa/suites/fs/workload/tasks/5-workunit/postgres.yaml b/qa/suites/fs/workload/tasks/5-workunit/postgres.yaml index 12a84a9ba7c..7e71dbc884d 100644 --- a/qa/suites/fs/workload/tasks/5-workunit/postgres.yaml +++ b/qa/suites/fs/workload/tasks/5-workunit/postgres.yaml @@ -30,7 +30,7 @@ tasks: - sudo -u postgres -- postgresql-setup --initdb - sudo ls -lZaR /tmp/cephfs/postgres/ - sudo systemctl start postgresql - - sudo -u postgres -- pgbench -s 500 -i + - sudo -u postgres -- pgbench -s 32 -i - sudo -u postgres -- pgbench -c 100 -j 4 --progress=5 --time=900 - sudo systemctl stop postgresql - sudo ls -lZaR /tmp/cephfs/postgres/ -- 2.39.5