Jim C. Nasby napisał(a):
That link isn't working for me,
Uppssss sorry... now it should work OK.
but if you're seeing 'spikey'
performance I'd bet that you need to change the bg_writer settings to
make it more aggressive, especially if you're seeing performance drops
Every 5 minutes (assuming default checkpoint settings).
You might also want to up wal_buffers and maybe checkpoint_segments.
OK many thanks, I will check.
On Wed, Nov 09, 2005 at 03:26:51PM +0100, Marcin Giedz wrote:
Hello.
I made some test comparing postgresql 8.0.4 based on two servers.
Here is a link:
http://85.128.68.44/
From my point of view it seems like:
- with opteron I found that it works very FAST periodicaly, why??? Maybe I
did something wrong or.....
- xeon seems to work almost all time on the same level but has much less
performance than opteron. Is it normal?
Did anyone has similar tests/results?
BR,
Marcin
---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match
---------------------------(end of broadcast)---------------------------
TIP 1: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to majordomo@xxxxxxxxxxxxxx so that your
message can get through to the mailing list cleanly
