Re: PostgreSQL crashes with Qmail-SQL

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