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 1947511F661D for ; Wed, 29 Mar 2006 10:05:15 -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 44603-01 for ; Wed, 29 Mar 2006 10:05:14 -0400 (AST) X-Greylist: domain auto-whitelisted by SQLgrey- Received: from zproxy.gmail.com (zproxy.gmail.com [64.233.162.200]) by postgresql.org (Postfix) with ESMTP id 30D8411F6616 for ; Wed, 29 Mar 2006 10:05:11 -0400 (AST) Received: by zproxy.gmail.com with SMTP id l1so173704nzf for ; Wed, 29 Mar 2006 06:05:12 -0800 (PST) DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=beta; d=gmail.com; h=received:message-id:date:from:to:subject:cc:in-reply-to:mime-version:content-type:content-transfer-encoding:content-disposition:references; b=SqWWVb3Afpm0Ovpo6qMKTvFODbqnFmPJqmKwJdm5JhebJZ4bEb6v4oVDDsWp3f7CbZYd/it+RUSLQ7hkz9Hx7CctdLOyFB5H/Wn05MQDD0q3cZWG79T8/zcGbvDSCHa467jWqX3yJYutZN4ABMPpD9S1KNr6gKLGAyHjDQ11CLA= Received: by 10.65.59.19 with SMTP id m19mr505568qbk; Wed, 29 Mar 2006 06:05:12 -0800 (PST) Received: by 10.65.135.6 with HTTP; Wed, 29 Mar 2006 06:05:12 -0800 (PST) Message-ID: Date: Wed, 29 Mar 2006 09:05:12 -0500 From: "Merlin Moncure" To: "Greg Quinn" Subject: Re: Slow performance on Windows .NET and OleDb Cc: pgsql-performance@postgresql.org In-Reply-To: <000f01c6531f$fcbc0570$0200a8c0@pta.homex.co.za> MIME-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable Content-Disposition: inline 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> X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, score=0.157 required=5 tests=[AWL=0.157] X-Spam-Score: 0.157 X-Spam-Level: X-Archive-Number: 200603/583 X-Sequence-Number: 18020 On 3/29/06, 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. esilo=3D# create temp table use_npgsql as select v, 12345 as a, 'abcdef' as b, 'abcdef' as c, 4 as d from generate_series(1,100000) v; SELECT Time: 203.000 ms esilo=3D# explain analyze select * from use_npgsql; QUERY PLAN ---------------------------------------------------------------------------= ---------------------------------------- Seq Scan on use_npgsql (cost=3D0.00..1451.16 rows=3D61716 width=3D76) (actual time=3D0.007..176.106 rows=3D100000 loops=3D1) Total runtime: 336.809 ms (2 rows) I just pulled out 100k rows in about 1/3 second. The problem is not your postgresql configuration. Your problem is possibly in the oledb driver. The last time I looked at it, it was not production ready. http://pgfoundry.org/frs/?group_id=3D1000140&release_id=3D407 Merlin