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(at)digibel(dot)be>
> > To: Justin Clift <justin(at)postgresql(dot)org>
> > References: <3C48F4B9(dot)AC03E251(at)postgresql(dot)org>
> > <20020119122728(dot)A9661(at)digibel(dot)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(at)Yahoo(dot)com #

_________________________________________________________
Do You Yahoo!?
Get your free @yahoo.com address at http://mail.yahoo.com