By Far The Postresql. From mysql after the appearance in the ninth version of the replication out of the box was gone plus the latest mysql.
\r
Postgra much more advanced database, to list its capabilities is endless, and here are a couple of things that are very, very helpful.
— Indexes on expression
— Partial indexes
— Non-blocking index updates
— Super fast removing and adding columns in tables of any size
— The experience many times less of deadlocks under heavy loads
— Multiple types of indexes
— The number of types is huge, plus user-defined types
— More precisely meets ANSI standard is much stricter and applies to the input data
cheques, rules, Treherne functions
— Full-text search module (muscular only for myisam and nervously smokes on the sidelines)!
— Transactional ddl!
— Ability to write procedures in almost any language, a powerful internal language PL/pgSQL (in the muscle squalor with a bunch of restrictions)
— Runs much better on multicore systems
— Advanced optimizer
\r
and much more more.
