X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (av.hub.org [200.46.204.144]) by postgresql.org (Postfix) with ESMTP id DC5FF11F662F for ; Wed, 29 Mar 2006 07:00:18 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 95339-06 for ; Wed, 29 Mar 2006 07:00:17 -0400 (AST) X-Greylist: from auto-whitelisted by SQLgrey- Received: from ctb-mesg4.saix.net (ctb-mesg4.saix.net [196.25.240.74]) by postgresql.org (Postfix) with ESMTP id 22BDE11F600D for ; Wed, 29 Mar 2006 07:00:15 -0400 (AST) Received: from greg (dsl-145-175-122.telkomadsl.co.za [165.145.175.122]) by ctb-mesg4.saix.net (Postfix) with SMTP id 438703C2F for ; Wed, 29 Mar 2006 13:00:15 +0200 (SAST) Message-ID: <000f01c6531f$fcbc0570$0200a8c0@pta.homex.co.za> Reply-To: "Greg Quinn" From: "Greg Quinn" To: References: <000d01c65261$19a3fa40$0200a8c0@pta.homex.co.za> <20060328173213.GO75181@pervasive.com> <442977D7.5060508@commandprompt.com> <006c01c652f9$1ca9c420$0200a8c0@pta.homex.co.za> Subject: Re: Slow performance on Windows .NET and OleDb Date: Wed, 29 Mar 2006 13:00:20 +0200 MIME-Version: 1.0 Content-Type: text/plain; format=flowed; charset="utf-8"; reply-type=response Content-Transfer-Encoding: 7bit X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 6.00.2900.2670 X-MIMEOLE: Produced By Microsoft MimeOLE V6.00.2900.2670 X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, score=1.025 required=5 tests=[AWL=-0.786, RCVD_IN_WHOIS_BOGONS=1.811] X-Spam-Score: 1.025 X-Spam-Level: * X-Archive-Number: 200603/578 X-Sequence-Number: 18015 > how many rows does it return ? a few, or a lot ? 3000 Rows - 7 seconds - very slow Which client library may have a problem? I am using OleDb, though haven't tried the .NET connector yet. Network configuration?? I am running it off my home PC with no network. It is P4 2.4 with 1 Gig Ram. Windows XP ----- Original Message ----- From: "PFC" To: "Greg Quinn" Sent: Wednesday, March 29, 2006 11:02 AM Subject: Re: [PERFORM] Slow performance on Windows .NET and OleDb > >> select * from users >> which returns 4 varchar fields, there is no where clause > > how many rows does it return ? a few, or a lot ? > >> Yes, I am running the default postgres config. Basically I have been a >> MySQL user and thought I would like to check out PostGreSql. > > Good idea... > > From the tests I made, on simple queries like yours, with no joins, speed > pf pg 8.x is about the same as mysql 5.x ; that is to say very fast. If > you have a performance problem on something so basic, and moreover on > windows, it smells like a problem in the client library, or in the TCP > transport between client and server. > I remember messages saying postgres on windows was slow some time ago > here, and it turned out to be a problem in the network configuration of > the machine. >