Received: from magus.postgresql.org (magus.postgresql.org [87.238.57.229])
	by mail.postgresql.org (Postfix) with ESMTP id B055CA0FB34
	for <pgsql-performance@postgresql.org>;
	Wed,  4 Jul 2012 19:35:44 -0300 (ADT)
Received: from [2404:130:0:10::40:2] (helo=mail.catalyst.net.nz)
	by magus.postgresql.org with esmtp (Exim 4.72)
	(envelope-from <mark.kirkwood@catalyst.net.nz>) id 1SmYAe-000626-T8
	for pgsql-performance@postgresql.org; Wed, 04 Jul 2012 22:35:43 +0000
Received: from localhost (localhost [127.0.0.1])
	by mail.catalyst.net.nz (Postfix) with ESMTP id 77BB7329AC;
	Thu,  5 Jul 2012 10:35:23 +1200 (NZST)
X-Virus-Scanned: Debian amavisd-new at catalyst.net.nz
Received: from mail.catalyst.net.nz ([127.0.0.1])
	by localhost (bertrand.catalyst.net.nz [127.0.0.1]) (amavisd-new,
	port 10024)
	with ESMTP id 7Mp2qFkN3shX; Thu,  5 Jul 2012 10:35:22 +1200 (NZST)
Received: from [IPv6:2404:130:0:1000:982:3f18:550f:4cb] (unknown
	[IPv6:2404:130:0:1000:982:3f18:550f:4cb])
	(Authenticated sender: mark.kirkwood)
	by mail.catalyst.net.nz (Postfix) with ESMTPSA id C0447327FA;
	Thu,  5 Jul 2012 10:35:22 +1200 (NZST)
Message-ID: <4FF4C52A.7030104@catalyst.net.nz>
Date: Thu, 05 Jul 2012 10:35:22 +1200
From: Mark Kirkwood <mark.kirkwood@catalyst.net.nz>
User-Agent: Mozilla/5.0 (X11; Linux x86_64;
	rv:13.0) Gecko/20120615 Thunderbird/13.0.1
MIME-Version: 1.0
To: Reza Taheri <rtaheri@vmware.com>
CC: Craig Ringer <ringerc@ringerc.id.au>,
	"pgsql-performance@postgresql.org" <pgsql-performance@postgresql.org>,
	"Andy Bond (abond@redhat.com)" <abond@redhat.com>,
	Greg Kopczynski <gregwk@vmware.com>,
	Jignesh Shah <jshah@vmware.com>, Greg Smith <greg@2ndQuadrant.com>,
	Dave Page <dpage@pgadmin.org>
Subject: Re: Introducing the TPC-V benchmark, and its relationship
	to PostgreSQL
References: 
 <66CE997FB523C04E9749452273184C6C137CB88A82@exch-mbx-113.vmware.com>
	<4FF3D252.4070701@ringerc.id.au>
	<66CE997FB523C04E9749452273184C6C137CB88B48@exch-mbx-113.vmware.com>
In-Reply-To: 
 <66CE997FB523C04E9749452273184C6C137CB88B48@exch-mbx-113.vmware.com>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
X-Host-Lookup-Failed: Reverse DNS lookup failed for 2404:130:0:10::40:2
	(failed)
X-Pg-Spam-Score: -1.1 (-)
X-Archive-Number: 201207/19
X-Sequence-Number: 47200

On 05/07/12 06:24, Reza Taheri wrote:
>
> I'll pick up Greg's book. We had been focusing on functionality, but our focus will shift to performance soon. To be blunt, the team is very experienced in benchmarks and in database performance, but most of us are new to PGSQL.
>
>

The book is well worth a read - even if you are experienced (in fact you 
may get more out of it in that case). In addition I think it would be 
beneficial for you to share with us your non default tuning changes you 
made in postgresql.conf  etc (as others have requested) - one of the 
major benefits of an open source community is the input of many 
minds...however we need the basic information concerning setup etc to 
even begin to help.

regards

Mark