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 5E9F1536FA for ; Mon, 18 Apr 2005 10:01:42 -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 80205-10 for ; Mon, 18 Apr 2005 13:01:33 +0000 (GMT) Received: from vms046pub.verizon.net (vms046pub.verizon.net [206.46.252.46]) by svr1.postgresql.org (Postfix) with ESMTP id BB70F536D5 for ; Mon, 18 Apr 2005 10:01:33 -0300 (ADT) Received: from jfradkin ([63.162.100.127]) by vms046.mailsrvcs.net (Sun Java System Messaging Server 6.2 HotFix 0.04 (built Dec 24 2004)) with ESMTPA id <0IF500L7Q86PMHU1@vms046.mailsrvcs.net> for pgsql-performance@postgresql.org; Mon, 18 Apr 2005 08:01:38 -0500 (CDT) Date: Mon, 18 Apr 2005 09:01:43 -0400 From: "Joel Fradkin" Subject: FW: speed of querry? To: "PostgreSQL Perform" Message-id: <000501c54416$c5914b50$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: 7bit 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/392 X-Sequence-Number: 11789 Another odd thing is when I tried turning off merge joins on the XP desktop It took 32 secs to run compared to the 6 secs it was taking. On the Linux (4proc box) it is now running in 3 secs with the mergejoins turned off. Unfortunately it takes over 2 minutes to actually return the 160,000+ rows. I am guessing that is either network (I have gig cards on a LAN) or perhaps the ODBC driver (using PGADMIN III to do the select). I tried to run on psql on the server but it was putting it out to more. If I do it and use > test.txt will it run it all out so I can get a time? Does it display the time anywhere like in pgadminIII?