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.