Received: from localhost (maia-3.hub.org [200.46.204.184]) by postgresql.org (Postfix) with ESMTP id 23A609FB51E for ; Wed, 13 Jun 2007 07:26:26 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.184]) (amavisd-maia, port 10024) with ESMTP id 47426-07 for ; Wed, 13 Jun 2007 07:26:12 -0300 (ADT) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.5 Received: from ug-out-1314.google.com (ug-out-1314.google.com [66.249.92.174]) by postgresql.org (Postfix) with ESMTP id B07619FB47F for ; Wed, 13 Jun 2007 07:26:17 -0300 (ADT) Received: by ug-out-1314.google.com with SMTP id u2so405831uge for ; Wed, 13 Jun 2007 03:26:15 -0700 (PDT) DKIM-Signature: a=rsa-sha1; c=relaxed/relaxed; d=gmail.com; s=beta; h=domainkey-signature:received:received:message-id:date:from:user-agent:mime-version:to:cc:subject:references:in-reply-to:content-type:content-transfer-encoding:sender; b=BaFZ6WZlaqJTG6fFmLiga4ORcGeBye7Sv98eKPrUBJqOICZDTEWr7NXJ2GIkNahzz5tgGEwzRm1Cy8A1e9RoGvgPSYyA8djlmpJc3Kx89uhvfkZaX1OHMaIDiHfm5iucQqa/Vr4+aAvnlbH2wZrGMJdNLmvbE/J+FD3YNBX/Rvw= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=beta; h=received:message-id:date:from:user-agent:mime-version:to:cc:subject:references:in-reply-to:content-type:content-transfer-encoding:sender; b=COOf0DFpdPbWPUvdMOf963wFY08ApMqT0NfyPdgaNMllDL7sTqBrOGu2n5HEPk3s1avvoGITj/Sn4S6AKkylHny/VYjeVwPdzlyd8OR1YQEL67TopVp/clCU9zM0nfyTyi7pYt1CMG4Cogt/qEc2DNTFtERx4v6EaPBMjUR/oV0= Received: by 10.67.22.2 with SMTP id z2mr1187540ugi.1181730375811; Wed, 13 Jun 2007 03:26:15 -0700 (PDT) Received: from ?192.168.1.34? ( [82.3.243.4]) by mx.google.com with ESMTP id 27sm2608360ugp.2007.06.13.03.26.13 (version=SSLv3 cipher=RC4-MD5); Wed, 13 Jun 2007 03:26:14 -0700 (PDT) Message-ID: <466FC62B.2070901@enterprisedb.com> Date: Wed, 13 Jun 2007 11:25:47 +0100 From: Heikki Linnakangas User-Agent: Icedove 1.5.0.10 (X11/20070329) MIME-Version: 1.0 To: Christo Du Preez CC: pgsql-performance@postgresql.org Subject: Re: Performance Testing Utility References: <466FC610.6070206@mecola.com> In-Reply-To: <466FC610.6070206@mecola.com> Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200706/228 X-Sequence-Number: 25261 Christo Du Preez wrote: > Is there some kind of performance testing utility available for > postgresql Something I can run after installing postgresql to help me > identify if my installation is optimal. Not really. There's contrib/pgbench, but I wouldn't recommend using it for that purpose since the optimal configuration depends on your application, and pgbench is likely nothing like your application. -- Heikki Linnakangas EnterpriseDB http://www.enterprisedb.com