pgbench and scaling

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

Responses

Browse pgsql-general by date

  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.