Re: [phplib] MySQL or PostgreSQL? From: Alex Black (enigma <email protected>)
Date: 04/10/01

>> I heard that Postgres isn't quite suitable for some web applications,
>> because it doesn't do UPDATEs in-place. Instead, it creates new records,
>> and the garbage collection with VACUUM would require an exclusive lock.
>>
>> Is that right -- should I rather use MySQL for storing session data
>> and other fast-changing information?

It should be mentioned: Postgres is much more load-capable, i.e. it will
continue to function in extreme situations where mySQL would fail, and most
importantly, includes transaction support.

Those reasons are enough to select Postgres over mySQL for any "larger
scale" web application - but for smaller stuff mySQL really whips the
llama's ass! (go download winamp if that makes no sense)

_alex

---------------------------------------------------------------------
To unsubscribe, e-mail: phplib-unsubscribe <email protected>
For additional commands, e-mail: phplib-help <email protected>