the following link is a good article on the real-world,
multi-user performance of mysql and postgres. tim perdue
ported source forge from mysql to postgre and performed a
series of tests against the source forge code and database.
one chart shows postgres scaling up to 100 concurrent users
and serving pages very nicely while mysql craters at about
20.
enjoy!
rjsjr
http://www.phpbuilder.com/columns/tim20001112.php3
> -----Original Message-----
> From: pgsql-general-owner@postgresql.org
> [mailto:pgsql-general-owner@postgresql.org]On Behalf Of Sam Tregar
> Sent: Wednesday, August 29, 2001 3:01 PM
> To: Peter Eisentraut
> Cc: pgsql-general@postgresql.org
> Subject: Re: [GENERAL] RFC: PostgreSQL and MySQL comparison.
>
>
> On Wed, 29 Aug 2001, Peter Eisentraut wrote:
>
> > Okay, I answered them:
> >
> > http://webmail.postgresql.org/~petere/comparison.html
>
> Perhaps you should add some links to PostgreSQL's full-text
> searching
> solutions? It's hard to evaluate without some reference to
> what you're
> talking about.
>
> -sam
>
>
>
> ---------------------------(end of
> broadcast)---------------------------
> TIP 2: you can get off all lists at once with the unregister command
> (send "unregister YourEmailAddressHere" to
> majordomo@postgresql.org)
>