pg.ddx.io  pgsql-performance@postgresql.org mailing list archive  

help / color / mirror / Atom feed
From: Greg Smith <greg@2ndquadrant.com>
To: Craig James <craig_james@emolecules.com>
Cc: pgsql-performance@postgresql.org
Subject: Re: pgbench results on a new server
Date: Fri, 25 Jun 2010 15:03:30 -0400
Message-ID: <4C24FD82.4070100@2ndquadrant.com> (raw)
In-Reply-To: <4C24FB0D.4020701@emolecules.com>
References: <k2pda0294261004061437p9cd3810dqe9ce528b6ddb0873@mail.gmail.com>
	<m2m603c8f071004071413w1f2d2497hbbe07d9c6491848f@mail.gmail.com>
	<4BBCFB12.1010306@emolecules.com>
	<y2r72dbd3151004071556j22244233l8fa1db295b7f9cd3@mail.gmail.com>
	<r2q603c8f071004071747n3e56d12bo11c49885b8c2eb2e@mail.gmail.com>
	<4BBD3A17.90209@emolecules.com>
	<y2l72dbd3151004071950kfe09a98fqf0c9a136375260e2@mail.gmail.com>
	<v2u603c8f071004072007t323fe469lfdd8fa5f2a283890@mail.gmail.com>
	<4C23FD52.40508@emolecules.com>
	<23596.1277438692@sss.pgh.pa.us>
	<4C24B3BB.3070901@emolecules.com>
	<2286.1277477230@sss.pgh.pa.us>
	<4C24D679.7030701@emolecules.com>
	<6203.1277485291@sss.pgh.pa.us>
	<4C24FB0D.4020701@emolecules.com>

Craig James wrote:
> I've got a new server and want to make sure it's running well.

Any changes to the postgresql.conf file?  Generally you need at least a 
moderate shared_buffers (1GB or so at a minimum) and checkpoint_segments 
(32 or higher) in order for the standard pgbench test to give good results.


> pgbench -c20 -t 5000 -U test
> tps = 5789
> pgbench -c30 -t 3333 -U test
> tps = 6961
> pgbench -c40 -t 2500 -U test
> tps = 2945

General numbers are OK, the major drop going from 30 to 40 clients is 
larger than it should be.  I'd suggest running the 40 client count one 
again to see if that's consistent.  If it is, that may just be pgbench 
itself running into a problem.  It doesn't handle high client counts 
very well unless you use the 9.0 version that supports multiple pgbench 
workers with the "-j" option.

-- 
Greg Smith  2ndQuadrant US  Baltimore, MD
PostgreSQL Training, Services and Support
greg@2ndQuadrant.com   www.2ndQuadrant.us




view thread (6+ messages)  latest in thread

Message-ID: <4C24FD82.4070100@2ndquadrant.com>
Permalink:  ../4C24FD82.4070100@2ndquadrant.com/
Also on:    postgresql.org/message-id/4C24FD82.4070100@2ndquadrant.com

 · 

reply
Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-performance@postgresql.org
  Cc: greg@2ndquadrant.com, craig_james@emolecules.com
  Subject: Re: pgbench results on a new server
  In-Reply-To: <4C24FD82.4070100@2ndquadrant.com>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox