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 03E755324B for ; Wed, 13 Apr 2005 15:29:43 -0300 (ADT) 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 32783-10 for ; Wed, 13 Apr 2005 18:29:41 +0000 (GMT) Received: from vms040pub.verizon.net (vms040pub.verizon.net [206.46.252.40]) by svr1.postgresql.org (Postfix) with ESMTP id 994E452A8F for ; Wed, 13 Apr 2005 15:29:40 -0300 (ADT) Received: from jfradkin ([63.162.100.127]) by vms040.mailsrvcs.net (Sun Java System Messaging Server 6.2 HotFix 0.04 (built Dec 24 2004)) with ESMTPA id <0IEW00LYHE1H6ID3@vms040.mailsrvcs.net> for pgsql-performance@postgresql.org; Wed, 13 Apr 2005 13:29:42 -0500 (CDT) Date: Wed, 13 Apr 2005 14:29:51 -0400 From: "Joel Fradkin" Subject: Re: speed of querry? In-reply-to: <425D573B.3080208@archonet.com> To: "'Richard Huxton'" Cc: "'PostgreSQL Perform'" Message-id: <000001c54056$c8499dc0$797ba8c0@jfradkin> MIME-version: 1.0 X-MIMEOLE: Produced By Microsoft MimeOLE V6.00.2900.2180 X-Mailer: Microsoft Outlook, Build 10.0.6626 Content-type: text/plain; charset=us-ascii Content-transfer-encoding: quoted-printable Importance: Normal X-Priority: 3 (Normal) X-MSMail-priority: Normal X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0 tagged_above=0 required=5 tests= X-Spam-Level: X-Archive-Number: 200504/258 X-Sequence-Number: 11655 are you sure the query was identical in each case.=20 I just ran a second time same results ensuring that the query is the = same. Not sure why it is doing a column10 thing. Any ideas what to look for? Both data bases are a restore from the same backup file. One is running redhat the other XP, I believe both are the same version = of postgres except for the different platform (8.0.1 I am pretty sure). I just spent the morning with Dell hoping for some explanation from = them. They said I had to have the database on the same type of OS and hardware = for them to think the issue was hardware. They are escalating to the = software group. I did a default Redhat install so it very well may be an issue with my = lack of knowledge on Linux. He did mention by default the Perc4 do cache, so I may need to visit the data center to set the percs to not cache. -- Richard Huxton Archonet Ltd