Re: PostgreSQL crashes with Qmail-SQL

Justin Clift wrote:

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

I tried to grab his scripts but both his "here" links return a 404 Not
Found.

One interesting point ... he does:

* A failing query for the user.
* A query for the alias-user.
* A query for alias-username in the dotqmails-table.
* A query for alias-default in the dotqmails-table.

Four queries that most likely can be done with a single query ... gotta
wonder about these MySQL-trained wunderkinds and their ability to write
decent queries.

--
Don Baccus
Portland, OR
http://donb.photo.net, http://birdnotes.net, http://openacs.org