I'll have to pipe up and say that, empirically, mysql far outperforms
postgres on a non-state-of-the-art server. I have seen 10 simultaneous
connections to mysql and a system load of 0.1 versus 1 instance of postgres
(postmaster) and a load of over 2 (and with 3 instances of postmaster a load
of 8!)
I know that hardware is cheap and obviously if I was running exclusively
postgres I'd throw more ram and a faster CPU at it.
Regards,
Gary "SuperID" Huntress
=======================================================
FreeSQL.org offering free database hosting to developers
Visit http://www.freesql.org
----- Original Message -----
From: "Leon Mergen" <[EMAIL PROTECTED]>
To: "Dip" <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Saturday, June 09, 2001 3:24 PM
Subject: Re: Internals Of MySQL
> I recently read an article at Zend.com, showing that Postgres had better
> performance than MySQL... Offcourse, this is a very bad thing to say in
the
> MySQL mailing list, and I'm not really sure about it either, since so many
> praise MySQL...
>
> http://zend.com/zend/art/databases.php
>
> _________________________________________
> Leon Mergen
> [EMAIL PROTECTED]
> President of Operations
> BlazeBox, Inc.
> T: +31 31 735 03 03
> F: +31 31 735 03 08
> ICQ: 55677353
>
> ************************
> The information transmitted in this email is intended only for the
> person(s)or entity to which it is addressed and may contain confidential
> and/or privileged material. Any review, retransmission, dissemination or
> other use of, or taking of any action in reliance upon, this information
by
> persons or entities other than the intended recipient is prohibited. If
you
> received this email in error, please contact the sender and permanently
> delete the email from any computer.
>
>
> ----- Original Message -----
> From: "Dip" <[EMAIL PROTECTED]>
> To: <[EMAIL PROTECTED]>
> Sent: Saturday, June 09, 2001 8:55 PM
> Subject: Internals Of MySQL
>
>
> > Hi All,
> >
> > Im running some benchmarking tests on mysql, postgres and interbase
> > database servers.
> >
> > does anyone know the reasons why or know where i can find out some
> > technical reasons why the mysql database server is particularly good in
> > relation to the others or just by itself e.g. use of query optimisation
> > or indexing etc. I'm only looking at creates, selects, inserts, update
> > and delete statements.
> >
> > I've tried to look around for this on the net, but all i seem to get is
> > a big arguement consisting of the features lacking in mysql that are in
> > other databases e.g. ACID!!
> >
> > Thanks,
> >
> > Dipesh
> >
> >
> >
> >
> > ---------------------------------------------------------------------
> > Before posting, please check:
> > http://www.mysql.com/manual.php (the manual)
> > http://lists.mysql.com/ (the list archive)
> >
> > To request this thread, e-mail <[EMAIL PROTECTED]>
> > To unsubscribe, e-mail
> <[EMAIL PROTECTED]>
> > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
> >
> >
>
>
> ---------------------------------------------------------------------
> Before posting, please check:
> http://www.mysql.com/manual.php (the manual)
> http://lists.mysql.com/ (the list archive)
>
> To request this thread, e-mail <[EMAIL PROTECTED]>
> To unsubscribe, e-mail
<[EMAIL PROTECTED]>
> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
>
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
