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 f
Scott Marlowe pisze:
So still I don't get this: select * from table; on old server takes 0,5 sec,
on new one takes 6sec. Why there is so big difference? And it does not
matter how good or bad select is to measure performance, because I don't
measure the performance, I measure the relative diffe
Scott Marlowe pisze:
2010/5/14 Piotr Legiecki :
So what is the problem? My simple 'benchmarks' I have done with pgAdmin in
spare time.
pgAdmin is the latest 1.8.2 on both D and E.
Using pgAdmin on my (D) computer I have run SELECT * from some_table; and
noted the execution time on bo
Hi
I have a situation at my work which I simply don't understand and hope
that here I can find some explanations.
What is on the scene:
A - old 'server' PC AMD Athlon64 3000+, 2GB RAM, 1 ATA HDD 150GB, Debian
etch, postgresql 8.1.19
B - new server HP DL 360, 12GB RAM, Intel Xeon 8 cores CPU,
Hi
I have a situation at my work which I simply don't understand and hope
that here I can find some explanations.
What is on the scene:
A - old 'server' PC AMD Athlon64 3000+, 2GB RAM, 1 ATA HDD 150GB, Debian
etch, postgresql 8.1.19
B - new server HP DL 360, 12GB RAM, Intel Xeon 8 cores CPU, fas
