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" <jd@xxxxxxxxxxxxxxxxx>
To: "Jim C. Nasby" <jnasby@xxxxxxxxxxxxx>
Cc: "Greg Quinn" <greg@xxxxxxxxxxxxxx>; <pgsql-performance@xxxxxxxxxxxxxx>
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/
