Re: MySQL vs. PostgreSQL

On Thu, Jul 25, 2002 at 04:01:26PM -0400, Vincent Stoessel wrote:
> >
> > 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.

My experience differs greatly from yours here.

> I also like that fact that I can tell mysql to use
> specific indexes if I feel like it.

I haven't needed to do this on PostgreSQL ( but it would be nice )
but I have needed to on MySQL because of its bad index choices.

> 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.
>

Yes, that is something I miss on the sites where I use PostgreSQL.
( yes I use MySQL as well )

> I love postgres, but sometimes the mysql
> bashing goes way out hand on the list.
> No war please.
>

I would hardly call what I said bashing.  I would call it the
facts in my experience with both products.