PostgreSQL crashes with Qmail-SQL

Hi guys,

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?

???

Regards and best wishes,

Justin Clift

-------- 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>

> > 
> > It makes me wonder if the poor performance of PostgreSQL is still
> > relevant, and I'm wondering if you tuned the memory size of the
> > PostgreSQL database when you tested it.  The default memory allocation
> > gives really high CPU load and low performance, but this can be adjusted
> > much easier now.
> I didn't tune anything, but i'll redo my tests this weekend and play a little
> with it ;)

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.

-----------------------------------------------------------------------
Some people have told me they don't think a fat penguin really embodies 
the grace of Linux, which just tells me they have never seen a angry 
penguin charging at them in excess of 100mph. They'd be a lot more 
careful about what they say if they had  -- Linus Torvalds