Skip site navigation (1) Skip section navigation (2)

Re: Slow performance on Windows .NET and OleDb

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 (view raw or flat)
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/

In response to

pgsql-performance by date

Next:From: Theo KramerDate: 2006-03-29 10:52:31
Subject: Re: Indexes with descending date columns
Previous:From: Ruben Rubio ReyDate: 2006-03-29 06:58:07
Subject: Re: Slow performance on Windows .NET and OleDb

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group