Skip site navigation (1) Skip section navigation (2)

PostgreSQL crashes with Qmail-SQL

From: Justin Clift <justin(at)postgresql(dot)org>
To: PostgreSQL Hackers Mailing List <pgsql-hackers(at)postgresql(dot)org>
Subject: PostgreSQL crashes with Qmail-SQL
Date: 2002-01-23 23:50:52
Message-ID: 3C4F4C5C.2F248773@postgresql.org (view raw or flat)
Thread:
Lists: pgsql-hackers
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(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>

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

Responses

pgsql-hackers by date

Next:From: Stephan SzaboDate: 2002-01-24 00:07:07
Subject: Re: RFD: schemas and different kinds of Postgres objects
Previous:From: Bill StudenmundDate: 2002-01-23 23:47:55
Subject: Re: RFD: schemas and different kinds of Postgres objects

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group