This tutorial is focused on teaching PostgreSQL to professionals that are already experienced with MySQL or Oracle. Relational databases share a lot of similar concepts. You may find it easier if we help you relate the concepts of PostgreSQL with Oracle/MySQL. Thus, we would start with PostgreSQL Architecture for Oracle/MySQL DBAs. As we discuss from basics, even a beginner may adapt the concepts easily. Thus, the approach we take with this tutorial is to present an overview of the PostgreSQL architecture and operation in view of MySQL's and Oracle's. We'll mix lecture with hands-on work, having the audience apply the concepts we present in practice in a lab format before covering new ones, starting with a simple and quick installation of PostgreSQL and going all the way to setup and maintain a stand by replica. By the end of the day attendees shall walk away from this tutorial with a good understanding of how PostgreSQL works and feel confident enough about it.
Following are the main points being discussed in this tutorial :
Brief history of PostgreSQL and its features
PostgreSQL Architecture for MySQL/Oracle DBAs and beginners.
Installation of PostgreSQL
Creating/Start/Stop a PostgreSQL Cluster and the components of a Data Directory
PostgreSQL parameters/settings you need to know
PostgreSQL User Management
MVCC in PostgreSQL
VACUUM and Transaction ID Wraparound in PostgreSQL
Types of Indexes
EXPLAIN in PostgreSQL
Logical and Physical Backups and PITR
Avinash Vallarapu joined Percona in the month of May 2018. Before joining Percona, Avi worked as a Database Architect at OpenSCG for 2 Years and as a DBA Lead at Dell for 10 Years in Database technologies such as PostgreSQL, Oracle, MySQL and MongoDB. He has given several talks and trainings on PostgreSQL. He has good experience in performing Architectural Health Checks, Performance Tuning and Migrations to PostgreSQL Environments.