[Maia-users] Postgres vs Mysql

[Darrick Hartman]

Marc G. Fournier wrote:
> On Mon, 18 Sep 2006, David Morton wrote:
>
>> In my experience, postgres is slower.  Lately there have been reports 
>> of slowness from both databases concerning the bayes database 
>> implementation, but throwing that issue aside, I think I have seen 
>> mysql performing slightly better.
>>
>> Maia involves a lot of writes compared to reads.  (Was was amazed the 
>> other day watching iostat).  IIRC, Postgres is slower on heavy 
>> writing. (and also needs the infamous vacumn process)
>>
>> If anyone has a well tuned postgres server and would like to counter 
>> this thought, feel free. :)  (And then tell us how the heck to tune 
>> postgresql properly! )
>
> I'm running things on a PostgreSQL server, having switched from MySQL 
> a little while back ...
>
> 0. make sure you run 8.1.x
>
> 1. give it lots of shared memory
>
> 2. make sure you run the autovacuum daemon
>
> At least, that's all the tuning I've done on her ... and its running 
> on a shared server with other processes running ...
>
> I switched from MySQL due to repeated database corruption on the MySQL 
> side of things ... got tired of having to rebuild it from scratch ...
I've seen that as well.  My current install has some issues with innodb 
claiming that log sequence number bla bla is in the future.  And that my 
database may be corrupt.
My thinking is that if I have mysql and postgres both running on the 
box, I can leave email users and all sorts of web-based tools in mysql 
and if I have corruption that would involve taking Maia down in the 
future, I would not affect the majority of the functions on this box.  
While an inconvenience, filtering could be disabled for a brief period 
of time.

Darrick

-- 
Darrick Hartman
DJH Solutions, LLC
http://www.djhsolutions.com