Re: pgbench and scaling

From: Vick Khera <vivek(at)khera(dot)org>
To: "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org>
Subject: Re: pgbench and scaling
Date: 2016-11-18 15:14:11
Message-ID: CALd+dceTuux3UOQ=9nEpMF8PVf3_SYbiqcXxQzPSBcFKD-tzpg@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Thu, Nov 17, 2016 at 8:08 PM, Rakesh Kumar
<rakeshkumar464(at)outlook(dot)com> wrote:
> 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 the TPS numbers per pgbench? If so, then you're getting
10x490=4900 TPS system wide, or 20*280=5600 TPS system wide.

If those are total TPS numbers then you should check your disk
utilization and CPU utilization and see where your bottleneck is.

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message William Ivanski 2016-11-18 15:58:03 Re: Trim performance on 9.5
Previous Message Jehan-Guillaume de Rorthais 2016-11-18 14:48:00 Re: Streaming replication failover/failback