X-Original-To: pgsql-odbc-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [64.117.225.181]) by svr1.postgresql.org (Postfix) with ESMTP id 67289CC589; Wed, 16 Jul 2003 14:38:05 +0000 (GMT) Received: from svr1.postgresql.org ([64.117.224.193]) by localhost (svr5.postgresql.org [64.117.225.181]) (amavisd-new, port 10024) with ESMTP id 39968-02; Wed, 16 Jul 2003 14:38:14 +0000 (GMT) Received: from sss.pgh.pa.us (unknown [192.204.191.242]) by svr1.postgresql.org (Postfix) with ESMTP id 28D4ECBAEF; Wed, 16 Jul 2003 11:37:51 -0300 (ADT) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.12.9/8.12.9) with ESMTP id h6GEcGQ3018119; Wed, 16 Jul 2003 10:38:17 -0400 (EDT) To: albertca@jazzfree.com Cc: pgsql-odbc@postgresql.org, pgsql-performance@postgresql.org Subject: Re: [PERFORM] Bad performance using ODBC In-reply-to: <200307161615.13989.albertca@jazzfree.com> References: <200307161615.13989.albertca@jazzfree.com> Comments: In-reply-to Albert Cervera Areny message dated "Wed, 16 Jul 2003 16:15:01 +0200" Date: Wed, 16 Jul 2003 10:38:16 -0400 Message-ID: <18118.1058366296@sss.pgh.pa.us> From: Tom Lane X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200307/37 X-Sequence-Number: 3098 Albert Cervera Areny writes: > I have a performance problem using postgresql when the connection is made > via ODBC with a windows machine using the latests ODBC drivers (Windows) and > PostgreSQL 7.3.3 (Linux). Do you have logging turned on in the ODBC driver? I recall hearing that that adds a heck of a lot of overhead... regards, tom lane