Re: Pgbench performance tuning? - Mailing list pgsql-hackers

From Andres Freund
Subject Re: Pgbench performance tuning?
Date
Msg-id 20160804175303.yidw5znr6w43quvz@alap3.anarazel.de
Whole thread Raw
In response to Pgbench performance tuning?  (Greg Stark <stark@mit.edu>)
Responses Re: Pgbench performance tuning?
List pgsql-hackers
On 2016-08-04 18:48:31 +0100, Greg Stark wrote:
> I'm trying to run pgbench on a moderately beefy machine (4-core 3.4GHz
> with 32G of ram and md mirrored spinning rust drives) at scale 300
> with 32 clients with duration of 15min. I'm getting TPS numbers
> between 60-150 which seems surprisingly low to me and also to several
> people on IRC.

What's the config? Version? What activity does pidstat -d -l indicate?
How much WAL was generated?

Greetings,

Andres Freund



pgsql-hackers by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: Heap WARM Tuples - Design Draft
Next
From: Bruce Momjian
Date:
Subject: Re: Heap WARM Tuples - Design Draft