[SOLVED] What's The differences between MySQL and PostgreSQL

[climbjm]

I have heard that MySQL runs and does a lot more processing from the memory and PostgreSQL does a lot more from off the disk.  I guess this is if you have a power failure, there is less data loss.

The source I heard this from, is somewhat questionable.

Could someone please explain if this is true?
What are the true differences?  ???

Thank you for your time.
(If you can, please list links to documentation.  I've tried looking but cannot really find anything solid)

[the_oliver]

Not sure about the memory v. disk question... doesn't seem to make much sence to me!  If there is a power failur your going to lose the data regardles of where it is stored.

The main diffrence is that postgreSQL is truly open source.  This can allow much more room for individual develepment from the back-end side of things.  MySQL is much more common.  For example on most server with php installed MySQL comands are compiled, but pgsql arnt.  PostgreSQL is also capable of doing more back end.  For example calculations, meening a faster service in the program/web script/etc.  Also if you a running a serriously lage amount of data though a database postgreSQL may run a little faster. 

To a large extent i think its down to perfrance, and ultimatly the bult of the queiry comands are very similar!  I have never realy found a satisfactory awnser to the question 'whats the difference?'!!  Must also confes to being a little biast infavior of postgreSQL though!