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 C7F5111F626D for ; Wed, 29 Mar 2006 21:18:42 -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 87312-07 for ; Wed, 29 Mar 2006 21:18:40 -0400 (AST) X-Greylist: from auto-whitelisted by SQLgrey- Received: from houston.familyhealth.com.au (houston.au.fhnetwork.com [203.22.197.21]) by postgresql.org (Postfix) with ESMTP id BAFBE11F665F for ; Wed, 29 Mar 2006 21:18:37 -0400 (AST) Received: from houston.familyhealth.com.au (localhost [127.0.0.1]) by houston.familyhealth.com.au (Postfix) with ESMTP id 9FE4D24FF2; Thu, 30 Mar 2006 09:18:34 +0800 (WST) Received: from [127.0.0.1] (work-40.internal [192.168.0.40]) by houston.familyhealth.com.au (Postfix) with ESMTP id 12EB424FE2; Thu, 30 Mar 2006 09:18:33 +0800 (WST) Message-ID: <442B3282.8070204@calorieking.com> Date: Thu, 30 Mar 2006 09:21:06 +0800 From: Christopher Kings-Lynne User-Agent: Thunderbird 1.5 (Windows/20051201) MIME-Version: 1.0 To: Greg Quinn Cc: pgsql-performance@postgresql.org Subject: Re: Slow performance on Windows .NET and OleDb References: <000d01c65261$19a3fa40$0200a8c0@pta.homex.co.za> <20060328173213.GO75181@pervasive.com> <442977D7.5060508@commandprompt.com> <006c01c652f9$1ca9c420$0200a8c0@pta.homex.co.za> <000f01c6531f$fcbc0570$0200a8c0@pta.homex.co.za> In-Reply-To: <000f01c6531f$fcbc0570$0200a8c0@pta.homex.co.za> Content-Type: text/plain; charset=UTF-8; format=flowed Content-Transfer-Encoding: 7bit X-familyhealth-MailScanner-Information: Please contact the ISP for more information X-familyhealth-MailScanner: Found to be clean X-familyhealth-MailScanner-From: chris.kings-lynne@calorieking.com X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, score=0.111 required=5 tests=[AWL=0.111] X-Spam-Score: 0.111 X-Spam-Level: X-Archive-Number: 200603/595 X-Sequence-Number: 18032 You should run the select query from the psql utility to determine if it's PostgreSQL, or your OleDb driver that's being slow. It takes like 185ms on one of my tables to get 7000 rows. Greg Quinn wrote: >> 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. >> > > > > ---------------------------(end of broadcast)--------------------------- > TIP 3: Have you checked our extensive FAQ? > > http://www.postgresql.org/docs/faq -- Christopher Kings-Lynne Technical Manager CalorieKing Tel: +618.9389.8777 Fax: +618.9389.8444 chris.kings-lynne@calorieking.com www.calorieking.com