MySQL dominates many OLTP environments due to application support, high transaction rates, and low connection overhead. PostgreSQL has a powerful extension mechanism that offers great flexibility, a powerful query language, a robust type system, and a cost-based optimizer that can efficiently execute sophisticated queries.
It’s possible to take advantage of both systems by using MySQL to record transactions, then consolidating data from multiple MySQL-based applications into PostgreSQL while checking for inconsistencies. Then, you can run cross-application analytics efficiently and have confidence in the result.
Jeff Davis has been a member of the PostgreSQL community for more than 10 years. He’s contributed two major features – Synchronized Scans and Exclusion Constraints – and participated in patch review, conferences, and user groups.
Jeff works on DBMS internals for Aster Data, a data warehouse software company focused on analytics.
For information on exhibition and sponsorship opportunities at the conference, contact Yvonne Romaine at firstname.lastname@example.org
For media partnerships, contact mediapartners@ oreilly.com
For media-related inquiries, contact Maureen Jennings at email@example.com
To stay abreast of conference news and to receive email notification when registration opens, please sign up for the O'Reilly MySQL Conference Bulletin (login required).
View a complete list of O'Reilly MySQL Conference Contacts