[Maia-users] Postgres vs Mysql

[Marc G. Fournier]

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

----
Marc G. Fournier           Hub.Org Networking Services (http://www.hub.org)
Email . scrappy at hub.org                              MSN . scrappy at hub.org
Yahoo . yscrappy               Skype: hub.org        ICQ . 7615664