DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma;
	h=message-id:date:from:user-agent:mime-version:to:cc:subject
	:references:in-reply-to:content-type:content-transfer-encoding;
	b=FoCTzWQRnTJp9anuHZtiRRz/ZyfkGGGAX5izLXA+aecglDB6CvpAC7FAj2HNHGN3mE
	lETgHrIhObdxfGqlIltYPDL8RTSxZotJGviXikNGuKDw3TjqRC6RNBWRDfNa8DCy+gT+
	FcLA+R16zvDyzAxNrcyL/FEdzhCWQvbCyv5lg=
Message-ID: <4BED5A78.4020702@gmail.com>
Date: Fri, 14 May 2010 16:13:12 +0200
From: Yeb Havinga <yebhavinga@gmail.com>
User-Agent: Thunderbird 2.0.0.24 (Windows/20100228)
MIME-Version: 1.0
To: Kevin Grittner <Kevin.Grittner@wicourts.gov>
CC: Piotr Legiecki <piotrlg@ams.edu.pl>,
 pgsql-performance@postgresql.org
Subject: Re: old server, new server, same performance
References: <4BED4C98.1080206@ams.edu.pl>
	<4BED1234020000250003171D@gw.wicourts.gov>
In-Reply-To: <4BED1234020000250003171D@gw.wicourts.gov>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit

Kevin Grittner wrote:
> Piotr Legiecki <piotrlg@ams.edu.pl> wrote:
>  
>   
>> Why there is no difference in database speed between those two
>> machines?
>>     
>  
> Could you post the contents of the postgresql.conf files for both
> (stripped of comments) and explain what you're using for your
> benchmarks?  In particular, it would be interesting to know how many
> concurrent connections are active running what mix of queries.
>   
It would be also interesting to know how many disks are there in the new 
server, and the size of the database (select  
pg_size_pretty(pg_database_size('yourdb'))).

regards,
Yeb Havinga