Re: PostgreSQL a slow DB?

> MySQL 5 is quickly catching up. Maybe someone can
> elaborate on the
> advantages of Postgres over MySQL 5?
>
> thanks,
> -Sid

i can't speak for everyone, but for me...

1. the license is bsd.
2. the license is bsd.
3. the license is bsd.
4. mysql didn't have foreign keys when i started.
5. mysql has more bugs to deal with.
6. the higher end features were designed in / built in
pgsql from the beginning - not tacked on aftre the
fact. think integrated vs hacked.
7. mysql has no significant feature advantage over
pgsql (many argue pgsql's features are significantly
better), but has license, corporate (oracle) and bug
liabilities.
8. the pgsql mailing list rocks! ;-)  there are very
helpful folks here.  this may be true of mysql mailing
lists, too.  i don't know.

if you *know* the license issue will never be a
problem, and i doubt anyone really does (who can
predict the future?), and you already know mysql, it
may make sense to stay put with mysql vs learning
something entirely new.

however, if i were starting from scratch, i'd learn
pgsql (no buyer's remorse here - this db is great).
if i were worried about the license, i'd learn pgsql
and stop worrying.  if i were worried about oracle's
influence on mysql, i'd learn pgsql and stop worrying.
 if i wanted to improve my data integrity, i'd switch
to postgresql (bugs can chomp away at data).

this isn't to say that mysql is a bad db.  since it is
so popular, it definitely fulfills the needs of many
people.

i'm sure i'd do pretty decent with it, too, if i had
to.

but i'm a happy customer here - and happy customers
stay put.  actually, i'm more than happy.  i'm
astounded that something like this exists under a
license like bsd.  astounded.

hth

oe1

__________________________________________________
Do You Yahoo!?
Tired of spam?  Yahoo! Mail has the best spam protection around
http://mail.yahoo.com