Understanding PostgreSQL for the MySQL Developer and DBA

This focused technical session provides MySQL DBAs and developers with essential knowledge for understanding PostgreSQL's key differences and similarities. The session prioritizes practical, high-impact distinctions that affect day-to-day operations and development.

Some topics that will be covered, include:

* Process vs Thread Mode - lPostgreSQL's one-process-per-connection vs MySQL's thread model, with the impact on resource management, and monitoring, and connection handling implications

* Key Terminology Mapping - Databases vs Schemas conceptual differences, tablespaces and file organization, system catalogs vs INFORMATION_SCHEMA

* Authentication and Authorization - Role-based access vs MySQL's user privileges, and password authentication differences

* VACUUM vs InnoDB's automatic cleanup

* Transaction handling and MVCC implementation

* Backup/restore methodology differences

* Syntax adjustments - string concatenation, SERIAL vs AUTO_INCREMENT, RETURNING clause vs last_insert_id(), and case sensitivity

* Transaction behaviour changes - default isolation level differences

Come to this talk and learn to transfer your skills as a MySQL developer or DBA, to hit the ground running in the PostgreSQL world.