X-Original-To: pgsql-odbc-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id B15D5533DE for ; Sat, 23 Apr 2005 11:18:37 -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 44164-09 for ; Sat, 23 Apr 2005 14:18:28 +0000 (GMT) Received: from vms048pub.verizon.net (vms048pub.verizon.net [206.46.252.48]) by svr1.postgresql.org (Postfix) with ESMTP id AC74054249 for ; Sat, 23 Apr 2005 11:18:26 -0300 (ADT) Received: from jfradkin ([63.162.100.127]) by vms048.mailsrvcs.net (Sun Java System Messaging Server 6.2 HotFix 0.04 (built Dec 24 2004)) with ESMTPA id <0IFE00A7LL2U5ME6@vms048.mailsrvcs.net> for pgsql-odbc@postgresql.org; Sat, 23 Apr 2005 09:18:31 -0500 (CDT) Date: Sat, 23 Apr 2005 10:18:31 -0400 From: "Joel Fradkin" Subject: Re: [PERFORM] Joel's Performance Issues WAS : Opteron vs Xeon In-reply-to: To: "'Mohan, Ross'" , Message-id: <001801c5480f$54573d80$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/63 X-Sequence-Number: 5222 Hate to be dumb, but unfortunately I am. Could you give me an idea what I should be using, or is there a good resource for me to check out. I have been spending so much time with config and moving data, = converting etc, I never looked at the odbc settings (didn't even think about it = until Josh brought it up). I did ask him for his advice, but would love a = second opinion. Our data is a bit of a mixture, some records have text items most are varchars and integers with a bit of Booleans mixed in. I am running 8.0.2 so not sure if the protocol is ODBC or Postgres? Thanks for responding I appreciate any help=20 Joel Fradkin =20 -----Original Message----- From: pgsql-odbc-owner@postgresql.org [mailto:pgsql-odbc-owner@postgresql.org] On Behalf Of Mohan, Ross Sent: Thursday, April 21, 2005 10:01 AM To: pgsql-odbc@postgresql.org Subject: Re: [ODBC] [PERFORM] Joel's Performance Issues WAS : Opteron vs Xeon Joel, thanks. A couple of things jump out there for me, not a problem for a routine ODBC connection, but perhaps in the "lotsa stuff" context of your current explorations, it might be relevant? I am completely shooting from the hip, here, but...if it were my goose to cook, I'd be investigating Session("StringConn") =3D "DRIVER=3D{PostgreSQL};DATABASE=3Dwazagua;SERVER=3D192.168.123.252;PORT=3D= 5432;UID=3D; PWD=3D;ReadOnly=3D0;Protocol=3D6.4; || Protocol? Is this related to version? is the driver waaaay old? FakeOidIndex=3D0;ShowOidColumn=3D0;RowVersioning=3D0; ShowSystemTables=3D0;ConnSettings=3D;Fetch=3D100; || Fetch great for OLTP, lousy for batch? Socket=3D4096;UnknownSizes=3D0;MaxVarcharSize=3D254;MaxLongVarcharSize=3D= 8190; || what ARE the datatypes and sizes in your particular case?=20 Debug=3D0; || a run with debug=3D1 probably would spit up something = interesting.... CommLog=3D0;Optimizer=3D1; || Optimizer? that's a new one on me.... Ksqo=3D1;UseDeclareFetch=3D0;TextAsLongVarchar=3D1;UnknownsAsLongVarchar=3D= 0;BoolsAs Char=3D1;Parse=3D0;CancelAsFreeStmt=3D;ExtraSysTablePrefixes=3Ddd_;LFConv= ersion=3D1;Up datableCursors=3D1;DisallowPremature=3D0;TrueIsMinus1=3D0;BI=3D0;ByteaAsL= ongVarBinar y=3D0;UseServerSidePrepare=3D0" || that's about all I can see, prima facie. I'll be very curious to = know if ODBC is any part of your performance equation.=20 HTH,=20 Ross -----Original Message----- From: Joel Fradkin [mailto:jfradkin@wazagua.com]=20 Sent: Thursday, April 21, 2005 10:54 AM To: Mohan, Ross Cc: pgsql-odbc@postgresql.org; PostgreSQL Perform Subject: RE: [PERFORM] Joel's Performance Issues WAS : Opteron vs Xeon Here is the connect string I am using. It could be horrid as I cut it from ODBC program. Session("StringConn") =3D "DRIVER=3D{PostgreSQL};DATABASE=3Dwazagua;SERVER=3D192.168.123.252;PORT=3D= 5432;UID=3D; PWD=3D;ReadOnly=3D0;Protocol=3D6.4;FakeOidIndex=3D0;ShowOidColumn=3D0;Row= Versioning=3D0; ShowSystemTables=3D0;ConnSettings=3D;Fetch=3D100;Socket=3D4096;UnknownSiz= es=3D0;MaxVar charSize=3D254;MaxLongVarcharSize=3D8190;Debug=3D0;CommLog=3D0;Optimizer=3D= 1;Ksqo=3D1;Us eDeclareFetch=3D0;TextAsLongVarchar=3D1;UnknownsAsLongVarchar=3D0;BoolsAs= Char=3D1;Pa rse=3D0;CancelAsFreeStmt=3D0;ExtraSysTablePrefixes=3Ddd_;LFConversion=3D1= ;UpdatableC ursors=3D1;DisallowPremature=3D0;TrueIsMinus1=3D0;BI=3D0;ByteaAsLongVarBi= nary=3D0;UseS erverSidePrepare=3D0" Joel Fradkin =20 -----Original Message----- From: Mohan, Ross [mailto:RMohan@arbinet.com]=20 Sent: Thursday, April 21, 2005 9:42 AM To: jfradkin@wazagua.com Subject: RE: [PERFORM] Joel's Performance Issues WAS : Opteron vs Xeon FWIW, ODBC has variables to tweak, as well. fetch/buffer sizes, and the like.=20 Maybe one of the ODBC cognoscenti here can chime in more concretely.... ---------------------------(end of broadcast)--------------------------- TIP 7: don't forget to increase your free space map settings