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 59FFE9DC8A7 for ; Tue, 28 Mar 2006 13:52:59 -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 17908-06 for ; Tue, 28 Mar 2006 13:52:55 -0400 (AST) X-Greylist: from auto-whitelisted by SQLgrey- Received: from projects.commandprompt.com (host-130.commandprompt.net [207.173.203.130]) by postgresql.org (Postfix) with ESMTP id 95A4C9DC848 for ; Tue, 28 Mar 2006 13:52:53 -0400 (AST) Received: from [192.168.1.5] (or-67-76-146-141.sta.sprint-hsd.net [67.76.146.141]) (authenticated bits=0) by projects.commandprompt.com (8.13.4/8.13.4) with ESMTP id k2SHqPDr010908; Tue, 28 Mar 2006 09:52:26 -0800 Message-ID: <442977D7.5060508@commandprompt.com> Date: Tue, 28 Mar 2006 09:52:23 -0800 From: "Joshua D. Drake" Organization: Command Prompt, Inc. User-Agent: Mail/News 1.5 (X11/20060309) MIME-Version: 1.0 To: "Jim C. Nasby" CC: Greg Quinn , 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> In-Reply-To: <20060328173213.GO75181@pervasive.com> Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: ClamAV version 0.88, clamav-milter version 0.87 on projects.commandprompt.com X-Virus-Status: Clean X-Greylist: Sender succeded SMTP AUTH authentication, not delayed by milter-greylist-1.6 (projects.commandprompt.com [192.168.2.159]); Tue, 28 Mar 2006 09:52:26 -0800 (PST) X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, score=0.091 required=5 tests=[AWL=0.091] X-Spam-Score: 0.091 X-Spam-Level: X-Archive-Number: 200603/553 X-Sequence-Number: 17990 Jim C. Nasby wrote: > On Tue, Mar 28, 2006 at 02:14:00PM +0200, Greg Quinn wrote: >> Hello, >> >> I have just installed PostGreSql 8.1 on my Windows XP PC. I created a >> simple table called users with 4 varchar fields. >> >> I am using the OleDb connection driver. In my .NET application, I populate >> 3000 records into the table to test PostGreSql's speed. It takes about 3-4 >> seconds. >> >> Even worse is displaying the 3000 records in a ListView control. It takes >> about 7 seconds. In MySQL, the exact same table and application displays >> the same 3000 records in under 1/2 second!!! > > Have you vacuumed recently? This smells like it might be a table bloat > problem. This could be a lot of things... He is probably running the default postgresql.conf which is going to perform horribly. What is your work_mem? shared_buffers? Are you passing a where clause? If so is there an index on the field that is subject to the clause? When you do the population, is it via inserts or copy? Joshua D. Drake -- === The PostgreSQL Company: Command Prompt, Inc. === Sales/Support: +1.503.667.4564 || 24x7/Emergency: +1.800.492.2240 Providing the most comprehensive PostgreSQL solutions since 1997 http://www.commandprompt.com/