X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 2469C3A4915 for ; Thu, 4 Nov 2004 21:06:07 +0000 (GMT) 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 22462-10 for ; Thu, 4 Nov 2004 21:06:03 +0000 (GMT) Received: from mail.atua.com.br (unknown [200.248.138.61]) by svr1.postgresql.org (Postfix) with ESMTP id DFC283A4961 for ; Thu, 4 Nov 2004 21:06:03 +0000 (GMT) Received: from [10.0.0.171] (ns2.atua.com.br [200.248.138.60]) by mail.atua.com.br (Postfix) with ESMTP id AA99F1EC3FE for ; Thu, 4 Nov 2004 19:06:01 -0200 (BRST) Subject: Better Hardware, worst Results From: Alvaro Nunes Melo To: Pgsql-Performance Content-Type: text/plain Message-Id: <1099602361.7775.15.camel@localhost> Mime-Version: 1.0 X-Mailer: Ximian Evolution 1.4.6 Date: Thu, 04 Nov 2004 19:06:01 -0200 Content-Transfer-Encoding: 7bit X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.0 tagged_above=0.0 required=5.0 tests= X-Spam-Level: X-Archive-Number: 200411/63 X-Sequence-Number: 9017 Hi, I have a very tricky situation here. A client bought a Dell dual-machine to be used as Database Server, and we have a cheaper machine used in development. With identical databases, configuration parameters and running the same query, our machine is almost 3x faster. I tried to increase the shared_buffers and other parameters, but the result is still the same. I would like to know what can I do to check what can be "holding" the Dell server (HD, memory, etc). Both machines run Debian Linux. I'll post configuration details below, so you'll can figure my scenario better. ==> Dell PowerEdge: HD: SCSI processor : 0 vendor_id : GenuineIntel cpu family : 15 model : 2 model name : Intel(R) Xeon(TM) CPU 2.80GHz stepping : 9 cpu MHz : 2791.292 cache size : 512 KB processor : 1 vendor_id : GenuineIntel cpu family : 15 model : 2 model name : Intel(R) Xeon(TM) CPU 2.80GHz stepping : 9 cpu MHz : 2791.292 cache size : 512 KB # free -m total used free shared buffers cached Mem: 1010 996 14 0 98 506 ==> Other machine: HD: IDE processor : 0 vendor_id : GenuineIntel cpu family : 15 model : 2 model name : Intel(R) Pentium(R) 4 CPU 2.26GHz stepping : 5 cpu MHz : 2262.166 cache size : 512 KB #free -m total used free shared buffers cached Mem: 439 434 4 0 16 395 -- +---------------------------------------------------+ | Alvaro Nunes Melo Atua Sistemas de Informacao | | al_nunes@atua.com.br www.atua.com.br | | UIN - 42722678 (54) 327-1044 | +---------------------------------------------------+