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 4785E11F665C for ; Wed, 29 Mar 2006 02:22:06 -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 34400-06 for ; Wed, 29 Mar 2006 02:22:04 -0400 (AST) X-Greylist: delayed 18:08:09.707901 by SQLgrey- Received: from ctb-mesg7.saix.net (ctb-mesg7.saix.net [196.25.240.77]) by postgresql.org (Postfix) with ESMTP id F386A11F640B for ; Wed, 29 Mar 2006 02:22:03 -0400 (AST) Received: from greg (dsl-145-175-122.telkomadsl.co.za [165.145.175.122]) by ctb-mesg7.saix.net (Postfix) with SMTP id 7D8E9375E for ; Wed, 29 Mar 2006 08:22:01 +0200 (SAST) Message-ID: <006c01c652f9$1ca9c420$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> Subject: Re: Slow performance on Windows .NET and OleDb Date: Wed, 29 Mar 2006 08:22:08 +0200 MIME-Version: 1.0 Content-Type: text/plain; format=flowed; charset="iso-8859-1"; 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=0.12 required=5 tests=[AWL=0.120] X-Spam-Score: 0.12 X-Spam-Level: X-Archive-Number: 200603/573 X-Sequence-Number: 18010 The query is, select * from users which returns 4 varchar fields, there is no where clause Yes, I am running the default postgres config. Basically I have been a MySQL user and thought I would like to check out PostGreSql. So I did a quick performance test. The performance was so different that I thought PostGreSQL was nothing compared to MySQL, but now it seems its just a few configuration options. Strange how the defult config would be so slow... I have begun reading the documentation but am not too sure what options I can quickly tweak to get good performance, could somebody give me some tips? Thanks ----- Original Message ----- From: "Joshua D. Drake" To: "Jim C. Nasby" Cc: "Greg Quinn" ; Sent: Tuesday, March 28, 2006 7:52 PM Subject: Re: [PERFORM] Slow performance on Windows .NET and OleDb > 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/ > >