From: | Vincent Stoessel <vincent(at)xaymaca(dot)com> |
---|---|
To: | Christopher Weimann <cweimann(at)k12hq(dot)com>, pgsql-general(at)postgresql(dot)org |
Subject: | Re: MySQL vs. PostgreSQL |
Date: | 2002-07-25 20:01:26 |
Message-ID: | 3D405916.8090202@xaymaca.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Christopher Weimann wrote:
> On Fri, Jul 12, 2002 at 04:52:11PM +0900, Curt Sampson wrote:
>
>>For some definition of "useful." You say in your table that postgres
>>is slower. How did you measure this?
>>
>
>
> In my personal experiance PostgreSQL runs circles around MySQL.
> Specifically MySQL makes lousy choices about which indexes to
> use and requires me to give it hints. PostgreSQL just works.
>
>
>
I use both databases depending on the project requirements. But
I find that mysql is more willing to use your indexes than
postgres is. I also like that fact that I can tell mysql to use
specific indexes if I feel like it. Plus the ability to add ,delete
and modify the name and type of any field , table or database is a
fat fingered admin's dream. I love postgres, but sometimes the mysql
bashing goes way out hand on the list.
No war please.
--
Vincent Stoessel
Linux Systems Developer
vincent xaymaca.com
From | Date | Subject | |
---|---|---|---|
Next Message | Robert Treat | 2002-07-25 20:12:17 | Re: archives dead again? |
Previous Message | Amin Abdulghani | 2002-07-25 20:01:00 | postgres 7.2.1 parse bug |