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 35B6F53A15 for ; Thu, 21 Apr 2005 11:36:11 -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 91828-10 for ; Thu, 21 Apr 2005 14:36:06 +0000 (GMT) Received: from vms044pub.verizon.net (vms044pub.verizon.net [206.46.252.44]) by svr1.postgresql.org (Postfix) with ESMTP id 8D8CB539D8 for ; Thu, 21 Apr 2005 11:36:05 -0300 (ADT) Received: from jfradkin ([63.162.100.127]) by vms044.mailsrvcs.net (Sun Java System Messaging Server 6.2 HotFix 0.04 (built Dec 24 2004)) with ESMTPA id <0IFA00GMIWKAK370@vms044.mailsrvcs.net> for pgsql-performance@postgresql.org; Thu, 21 Apr 2005 09:36:10 -0500 (CDT) Date: Thu, 21 Apr 2005 10:36:22 -0400 From: "Joel Fradkin" Subject: Re: Joel's Performance Issues WAS : Opteron vs Xeon In-reply-to: <11216.1114058132@sss.pgh.pa.us> To: "'Tom Lane'" , "'John A Meinel'" Cc: "'Postgresql Performance'" Message-id: <005201c5467f$7d6418b0$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=AWL X-Spam-Level: X-Archive-Number: 200504/563 X-Sequence-Number: 11960 I suspect he's using pgadmin. =20 Yup I was, but I did try running on the linux box in psql, but it was running to the screen and took forever because of that. The real issue is returning to my app using ODBC is very slow (Have not tested the ODBC for MYSQL, MSSQL is ok (the two proc dell is running out = of steam but been good until this year when we about doubled our demand by adding sears as a client). Using odbc to postgres on some of the views (Josh from Command is having = me do some very specific testing) is timing out with a 10 minute time = limit. These are pages that still respond using MSSQL (this is wehere = production is using the duel proc and the test is using the 4 proc). I have a tool that hooks to all three databases so I can try it with = that and see if I get different responses. Joel