From 497f951c0ddcb4be3921ef887f866eb534258537 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 --- 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 12a84a9ba7c98..7e71dbc884da7 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