From: Ruben Rubio Rey <ruben@rentalia.com>
To: pgsql-performance@postgresql.org
Subject: Re: Slow performance on Windows .NET and OleDb
Date: Wed, 29 Mar 2006 08:58:07 +0200
Message-ID: <442A2FFF.1080301@rentalia.com> (raw)
In-Reply-To: <006c01c652f9$1ca9c420$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>
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...
My english is poor but im gonna try to explain it:
Default configuration in postgres its not for good performance, its just
design to make it working in any computer. Thats why u have to try to
custom default config file.
Anyway, people says that mysql is faster (and lighter) than postgres (at
least with mysql 3.x vs postgres 7.4), but postgres is more advanced and
its much harder to get data corrupted.
But there is something that you should known about postgres. Postgres
creates statistics of usage, and when you "vacumm", it optimizes each
table depending of usage.
So:
- You should custom config file.
- You should vacumm it, as someone recomended before.
- Do u have any indexes? Remove it. To get all rows you do not need it
Note that I just have use it under Linux, i have no idea about how
should it work on Windows.
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: ruben@rentalia.com
Subject: Re: Slow performance on Windows .NET and OleDb
In-Reply-To: <442A2FFF.1080301@rentalia.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