From: Merlin Moncure <mmoncure@gmail.com>
To: Greg Quinn <greg@officium.co.za>
Cc: pgsql-performance@postgresql.org
Subject: Re: Slow performance on Windows .NET and OleDb
Date: Wed, 29 Mar 2006 09:05:12 -0500
Message-ID: <b42b73150603290605v598769bbka6dc187174d0da@mail.gmail.com> (raw)
In-Reply-To: <000f01c6531f$fcbc0570$0200a8c0@pta.homex.co.za>
References: <000d01c65261$19a3fa40$0200a8c0@pta.homex.co.za>
<20060328173213.GO75181@pervasive.com>
<442977D7.5060508@commandprompt.com>
<006c01c652f9$1ca9c420$0200a8c0@pta.homex.co.za>
<op.s653ebg3cigqcu@apollo13>
<000f01c6531f$fcbc0570$0200a8c0@pta.homex.co.za>
On 3/29/06, Greg Quinn <greg@officium.co.za> 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=# 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=# explain analyze select * from use_npgsql;
QUERY PLAN
-------------------------------------------------------------------------------------------------------------------
Seq Scan on use_npgsql (cost=0.00..1451.16 rows=61716 width=76)
(actual time=0.007..176.106 rows=100000 loops=1)
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=1000140&release_id=407
Merlin
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: mmoncure@gmail.com, greg@officium.co.za
Subject: Re: Slow performance on Windows .NET and OleDb
In-Reply-To: <b42b73150603290605v598769bbka6dc187174d0da@mail.gmail.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox