Re: Xeon vs Opteron - tests and questions

From: Marcin Giedz <marcin(dot)giedz(at)eulerhermes(dot)pl>
To: "Jim C(dot) Nasby" <jnasby(at)pervasive(dot)com>
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: Xeon vs Opteron - tests and questions
Date: 2005-11-09 18:49:23
Message-ID: 437244B3.3050605@eulerhermes.pl
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

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
>>
>>
>>
>
>
>

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Tom Lane 2005-11-09 19:19:09 Re: Xeon vs Opteron - tests and questions
Previous Message Jim C. Nasby 2005-11-09 18:15:04 Re: Xeon vs Opteron - tests and questions