Compare MySQL and PostgreSQL 
- Users report that PostgreSQL excels in data schema management with a score of 9.2, highlighting its advanced capabilities in handling complex data structures, while MySQL, with a score of 9.0, is noted for its simplicity but may lack some of the advanced features that PostgreSQL offers.
- Reviewers mention that PostgreSQL's ACID compliance is rated at 9.0, ensuring robust transaction reliability, whereas MySQL's score of 8.9 indicates it is also compliant but may not provide the same level of assurance in all scenarios.
- G2 users highlight PostgreSQL's superior text search capabilities with a score of 8.5, which is particularly beneficial for applications requiring full-text search, while MySQL's score of 8.4 suggests it is adequate but not as powerful in this area.
- Users on G2 report that PostgreSQL's advanced indexing features, rated at 8.8, allow for more efficient query performance, while MySQL's score of 8.6 indicates it performs well but may not match the flexibility offered by PostgreSQL's indexing options.
- Reviewers say that PostgreSQL's disaster recovery features, rated at 8.6, provide a more comprehensive solution for data protection compared to MySQL's score of 8.3, which may leave some users wanting more robust options.
- Users mention that both databases have strong security features, with PostgreSQL scoring 8.7 and MySQL at 8.4, but PostgreSQL is often praised for its more granular access control options, making it a preferred choice for security-conscious applications.
MySql simply works and works well. It is exactly as described: a robust, relational DB which scales nicely to 100s of millions of rows. Plus, many web developers are familiar with using it so there is no shortage of expertise available. If you are doing...
too many privileges are to be granted. too many actions by only system dba
I think PostgreSQL is a good Enterprise Class data management. It has good amount of features like integration, migration, flexible deployment options, has good tool kits for management. We've almost about 10+ databases including master and managing them...
Replication, at least in 2006-2007 was slony and log-shipping. Slony would fail to create new replicas after about 100 gigs on somewhat serious enterprise hardware due to it recreating the database via a pg_dump method which obviously stops working after...
MySql simply works and works well. It is exactly as described: a robust, relational DB which scales nicely to 100s of millions of rows. Plus, many web developers are familiar with using it so there is no shortage of expertise available. If you are doing...
I think PostgreSQL is a good Enterprise Class data management. It has good amount of features like integration, migration, flexible deployment options, has good tool kits for management. We've almost about 10+ databases including master and managing them...
too many privileges are to be granted. too many actions by only system dba
Replication, at least in 2006-2007 was slony and log-shipping. Slony would fail to create new replicas after about 100 gigs on somewhat serious enterprise hardware due to it recreating the database via a pg_dump method which obviously stops working after...
