From: Joshua D. Drake <jd@commandprompt.com>
To: Jim C. Nasby <jnasby@pervasive.com>
Cc: Greg Quinn <greg@officium.co.za>
Cc: pgsql-performance@postgresql.org
Subject: Re: Slow performance on Windows .NET and OleDb
Date: Tue, 28 Mar 2006 09:52:23 -0800
Message-ID: <442977D7.5060508@commandprompt.com> (raw)
In-Reply-To: <20060328173213.GO75181@pervasive.com>
References: <000d01c65261$19a3fa40$0200a8c0@pta.homex.co.za>
<20060328173213.GO75181@pervasive.com>
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/
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: jd@commandprompt.com, jnasby@pervasive.com, greg@officium.co.za
Subject: Re: Slow performance on Windows .NET and OleDb
In-Reply-To: <442977D7.5060508@commandprompt.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