[Maia-users] Postgres vs Mysql

[David Morton]

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Darrick Hartman wrote:
> Before I do such a thing, are there any benefits or drawbacks to using 

Let the flamewars begin... lol

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! )

- --
David Morton
Maia Mailguard                        - http://www.maiamailguard.com
Morton Software Design and Consulting - http://www.dgrmm.net
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.2.2 (GNU/Linux)
Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org

iD8DBQFFDra4Uy30ODPkzl0RAmasAJ912/y/qEZk5CRanfWCKgKN3wCM0ACgobrY
p3zm8STylJ28vP1pMEvgcLw=
=qnXd
-----END PGP SIGNATURE-----