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