Re: MySQL vs. PostgreSQL - Mailing list pgsql-general

From Adrian 'Dagurashibanipal' von Bidder
Subject Re: MySQL vs. PostgreSQL
Date
Msg-id 1026890778.20000.48.camel@atlas
Whole thread Raw
In response to Re: MySQL vs. PostgreSQL  (Christopher Weimann <cweimann@k12hq.com>)
List pgsql-general
On Tue, 2002-07-16 at 00:33, 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.

Weeeellll. While I'd never use mysql, I find postgres does not 'just
work' - it needs quite a bit attention:

 - running vacuum by hand (there was a recent debate on auto-running
vacuum when it's needed. I'll be happy to see this)
 - the default set up needs some tuning if your database grows to a
certain size (I've not come to that point in my tiny projects, I'm just
reading -general and -hackers cause I'm interested).

But if you assume a proper installation and administration of the
database, then I agree with you.

cheers
-- vbi

--
secure email with gpg                         http://fortytwo.ch/gpg

Attachment

pgsql-general by date:

Previous
From: Adrian 'Dagurashibanipal' von Bidder
Date:
Subject: Re: OIDs (Or: another RTFM question?)
Next
From: Ben Liblit
Date:
Subject: Re: dropping anonymous constraints