From: | Chris <dmagick(at)gmail(dot)com> |
---|---|
To: | Ruben Rubio Rey <ruben(at)rentalia(dot)com> |
Cc: | pgsql-performance(at)postgresql(dot)org |
Subject: | Re: Slow performance on Windows .NET and OleDb |
Date: | 2006-03-29 07:16:23 |
Message-ID: | 442A3447.9060304@gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-performance |
Ruben Rubio Rey wrote:
> Greg Quinn wrote:
>
>> 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...
> - Do u have any indexes? Remove it. To get all rows you do not need it
I wouldn't do that. Postgres needs indexing just like any other database.
It might affect this query but it's not going to help other queries.
--
Postgresql & php tutorials
http://www.designmagick.com/
From | Date | Subject | |
---|---|---|---|
Next Message | Theo Kramer | 2006-03-29 10:52:31 | Re: Indexes with descending date columns |
Previous Message | Ruben Rubio Rey | 2006-03-29 06:58:07 | Re: Slow performance on Windows .NET and OleDb |