[Maia-users] Postgres vs Mysql

[Alexandre Ghisoli]

David Morton <mortonda at dgrmm.net> a écrit :

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

Yes, like always while debating on this subject ..

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

 From my own experience, PostgreSQL is a *real* database system, and  
in the DB world, performances and data security (and data integrity)  
are impacted by a lot of parameters.

Look, MySQL was designed for low demand systems, and has grow much  
more than the initial design could allow. So, they have worked well to  
add stuff (and uses Berkley DB as transactional engine).

That said, I'm not sure who fit maia needs best.

I've worked a lot on PostgreSQL stuff to get a very good DB server for  
maia only, where we have 100's concurent users for 6'000 messages a  
days, load still under 20% now.

For sure, if you are ready to invest time and making your knowledge  
growth, go for PostgreSQL, they are a very good team, support, and  
provide terrabytes DB for real applications (in a SQL complient world  
!!)

If you dont want to spend time or get a small email gateway and not  
affraid by data loose, go for MySQL.



--Alexandre

----------------------------------------------------------------
YCOM SA                                       http://www.ycom.ch