Skip site navigation (1) Skip section navigation (2)

Re: old server, new server, same performance

From: Piotr Legiecki <piotrlg(at)ams(dot)edu(dot)pl>
To: Scott Marlowe <scott(dot)marlowe(at)gmail(dot)com>
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: old server, new server, same performance
Date: 2010-05-21 12:15:21
Message-ID: 4BF67959.2000507@ams.edu.pl (view raw or flat)
Thread:
Lists: pgsql-performance
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.

In response to

pgsql-performance by date

Next:From: Tyler HildebrandtDate: 2010-05-21 13:54:15
Subject: Query timing increased from 3s to 55s when used as functioninstead of select
Previous:From: venu madhavDate: 2010-05-21 09:39:46
Subject: Re: Autovacuum in postgres.

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group