From: | Rakesh Kumar <rakeshkumar464(at)outlook(dot)com> |
---|---|
To: | "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org> |
Subject: | pgbench and scaling |
Date: | 2016-11-18 01:08:37 |
Message-ID: | DM2PR05MB622F64BC155EA6384AF6A548CB00@DM2PR05MB622.namprd05.prod.outlook.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
PG 9.5.3
RHEL Linux
To cut the story short and giving as much details as I can remember:
I created 40 database db1 .. db40 in a cluster.
On each database I initialized pgbench tables with a scale of 15.
Then I concurrently ran 5 pgbenches for 15 min. Each pgbench connected to one db. In other words, no two pgbench sessions were working on the same db.
I noticed that as I scale from 5 to 10 to 20 to 40, the TPS starts falling almost linearly :
with 5, TPS was doing 639
with 10 TPS was down to 490
with 20 TPS was down to 280
and so on.
Are we missing something? Where do I start looking for the root cause.
thanks
From | Date | Subject | |
---|---|---|---|
Next Message | Rakesh Kumar | 2016-11-18 01:10:27 | Re: pgbench and scaling |
Previous Message | Kevin Grittner | 2016-11-17 22:19:20 | Re: pg_class (system) table increasing size. |