[wellylug] Storing Mail in an SQL database ? - Scaling of Postgresql

[Enkidu]

On Tue, 17 Feb 2004 11:38:06 +1300, you wrote:

>
>On 17/02/2004, at 9:51 AM, Nigel Walters wrote:
>
>> Phillip,
>>
>> You say that DBmail does not scale well with Postgresql ? Any idea why
>> not ?
>>
>> I am interested in using Postgresql rather then MySQL.
>
>It's in the DBmail readme, or was last time I used it. I have no idea 
>why, I know MySQL does SELECTs many times faster than Postgres. We're 
>talking in the region of 10,000 users here.
>
Well, I'm not convinced. See this fairly comprehensive comparison:

http://www.phpbuilder.com/columns/tim20000705.php3?page=1

I've tried both and settled on PostgreSQL. It feels a lot more "grown
up" than MySQL which I thought was fairly limited. I'm no database
guru, but it's nice to have the security of transactions if you want
then (though I've not often actually used them). I've never had a
database corruption with either database, and I'd like a few more
performance type tools with PostgreSQL, but I've never noticed it
being slow.

Cheers,

Cliff