Message-ID: <4BF67959.2000507@ams.edu.pl>
Date: Fri, 21 May 2010 14:15:21 +0200
From: Piotr Legiecki <piotrlg@ams.edu.pl>
User-Agent: Thunderbird 2.0.0.24 (Windows/20100228)
MIME-Version: 1.0
To: Scott Marlowe <scott.marlowe@gmail.com>
CC: pgsql-performance@postgresql.org
Subject: Re: old server, new server, same performance
References: <4BED08B4.4030507@sci.pam.szczecin.pl>	
	<AANLkTimf8KfFVGL5E3aVwGutNT1kveJmD4nsc2HtLnbn@mail.gmail.com>	
	<4BF0F8FF.5040703@ams.edu.pl>	
	<AANLkTilnF7pHezPdQjvoKq8slPr34uG_ZoSTv1ntKxi_@mail.gmail.com>	
	<AANLkTim_flRDNYlOsr3owClWvb0pRVCD_R5Xpx8r780A@mail.gmail.com>	
	<4BF111D1.2000101@ams.edu.pl>
	<AANLkTilbViyukciAw-CxcdunbwJllYlq7hexZlkvYHKF@mail.gmail.com>
In-Reply-To: <AANLkTilbViyukciAw-CxcdunbwJllYlq7hexZlkvYHKF@mail.gmail.com>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit

Scott Marlowe pisze:

> Is one connecting via SSL?  Is this a simple flat switched network, or
> are these machines on different segments connected via routers?

SSL is disabled.
It is switched network, all tested computers are in the same segment.


Finally I have switched the production database from old server to new 
one and strange things happened. The same query on new server I have 
used before with 30sec results now runs about 9 sec (so the same time as 
the old production server). Hm...

Is it possible that database under some load performs better because it 
makes some something that database  not used is not doing?


P.