| 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 |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| 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.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tyler Hildebrandt | 2010-05-21 13:54:15 | Query timing increased from 3s to 55s when used as function instead of select |
| Previous Message | venu madhav | 2010-05-21 09:39:46 | Re: Autovacuum in postgres. |