pg.ddx.io  pgsql-performance@postgresql.org mailing list archive  

help / color / mirror / Atom feed
From: Piotr Legiecki <piotrlg@ams.edu.pl>
To: Scott Marlowe <scott.marlowe@gmail.com>
Cc: pgsql-performance@postgresql.org
Subject: Re: old server, new server, same performance
Date: Fri, 21 May 2010 14:15:21 +0200
Message-ID: <4BF67959.2000507@ams.edu.pl> (raw)
In-Reply-To: <AANLkTilbViyukciAw-CxcdunbwJllYlq7hexZlkvYHKF@mail.gmail.com>
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>

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.



view thread (16+ messages)

Message-ID: <4BF67959.2000507@ams.edu.pl>
Permalink:  ../4BF67959.2000507@ams.edu.pl/
Also on:    postgresql.org/message-id/4BF67959.2000507@ams.edu.pl

 · 

reply
Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-performance@postgresql.org
  Cc: piotrlg@ams.edu.pl, scott.marlowe@gmail.com
  Subject: Re: old server, new server, same performance
  In-Reply-To: <4BF67959.2000507@ams.edu.pl>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox