Stephan Szabo wrote:
>
> On Thu, 24 Jan 2002, Justin Clift wrote:
>
> > Michael Devogelaere, the guy who writes the QMail-SQL package has
> > recently started moving away from using PostgreSQL to MySQL.
> >
> > In his experience, MySQL works better. Now, he's just tested them over
> > the weekend, and what he reports is that PostgreSQL *crashes*. Doesn't
> > just go slow, but *crashes*.
> >
> > Would someone be able to take a look into this?
>
> I went to the page mentioned below and wanted to try grabbing the test
> scripts to see if I could replicate the crash, but got 404's for the
> testscripts.tgz link on the page. The speed doesn't surprise me as much
> as the crash does.
As the doc says, all done totally untuned. And CRASH by itself doesn't say anything. A little more precise
would be good.
Other than that, once again one of these mostly read only scenarios with simple queries where it is well known
that a real database cannot compete.
Jan
>
> > -------- Original Message --------
> > Subject: Re: Qmail-SQL
> > Date: Wed, 23 Jan 2002 15:17:12 +0100
> > From: Michael Devogelaere <michael@digibel.be>
> > To: Justin Clift <justin@postgresql.org>
> > References: <3C48F4B9.AC03E251@postgresql.org>
> > <20020119122728.A9661@digibel.be>
> >
> > Ok. I worked a bit on it this weekend and put the results on
> > http://qmail-sql.digibel.be/testing.html. I'm very sorry but
> > postgresql was between 3 and 4 times slower than mysql and didn't
> > survive all tests.
> >
> > Kind regards,
> > Michael Devogelaere.
>
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 6: Have you searched our list archives?
>
> http://archives.postgresql.org
>
--
#======================================================================#
# It's easier to get forgiveness for being wrong than for being right. #
# Let's break this rule - forgive me. #
#================================================== JanWieck@Yahoo.com #
_________________________________________________________
Do You Yahoo!?
Get your free @yahoo.com address at http://mail.yahoo.com