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?
In response to
pgsql-performance by date
|Next:||From: Tyler Hildebrandt||Date: 2010-05-21 13:54:15|
|Subject: Query timing increased from 3s to 55s when used as functioninstead of select|
|Previous:||From: venu madhav||Date: 2010-05-21 09:39:46|
|Subject: Re: Autovacuum in postgres.|