X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (av.hub.org [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 02A12D9F00 for ; Wed, 9 Nov 2005 14:50:49 -0400 (AST) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 29008-07 for ; Wed, 9 Nov 2005 18:50:46 +0000 (GMT) X-Greylist: delayed 04:23:54.785 by SQLgrey- Received: from mail.eulerhermes.pl (host-ip43-68.crowley.pl [85.128.68.43]) by svr1.postgresql.org (Postfix) with ESMTP id DF574D9EE8 for ; Wed, 9 Nov 2005 14:50:45 -0400 (AST) Received: from stunnel-ns1.warszawa-ext ([192.168.69.4] helo=[127.0.0.1] ident=nobody) by mail.eulerhermes.pl with esmtpa (Exim 4.42) id 1EZv1x-0002IA-M4; Wed, 09 Nov 2005 19:50:45 +0100 Message-ID: <437244B3.3050605@eulerhermes.pl> Date: Wed, 09 Nov 2005 19:49:23 +0100 From: Marcin Giedz User-Agent: Mozilla Thunderbird 1.0.6 (X11/20050716) X-Accept-Language: pl, en-us, en MIME-Version: 1.0 To: "Jim C. Nasby" Cc: pgsql-admin@postgresql.org Subject: Re: Xeon vs Opteron - tests and questions References: <200511091526.51685.marcin.giedz@eulerhermes.pl> <20051109181504.GF54605@pervasive.com> In-Reply-To: <20051109181504.GF54605@pervasive.com> Content-Type: text/plain; charset=UTF-8; format=flowed Content-Transfer-Encoding: 8bit X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, score=0.023 required=5 tests=[AWL=0.023] X-Spam-Score: 0.023 X-Spam-Level: X-Archive-Number: 200511/95 X-Sequence-Number: 19468 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 >> >> >> > > >