Presented by:
Avinash Vallarapu
Avinash Vallarapu (Avi) is the CEO and Founder of HexaCluster, a company specialized in Database Migrations, PostgreSQL Consulting, Application Migrations and Modernizations, and AI/ML Services. Before creating HexaCluster, Avi was the CEO and Co-founder of MigOps, specialized in database migrations to PostgreSQL. He created the PostgreSQL practice at Percona as a Global Services Lead and Product Owner, and worked as a Database Architect at OpenSCG and Dell. With a vast experience in technologies like Oracle, PostgreSQL, MySQL and MongoDB for the last 2 decades, Avi had co-authored multiple books on PostgreSQL : Beginning PostgreSQL on Cloud and PostgreSQL 13 Cookbook.
He spoke at various PostgreSQL Conferences in the past including -
- PGCONF India
- PGCON Ottawa
- Percona Live Frankfurt
- Postgres Conference New York
- Percona Live Texas
- Postgres Open Florida
- Postgres Conference Silicon Valley
- Percona Live
- GITEX Global
- and some more conferences.
His areas of expertise are PostgreSQL Migrations, Training and Consulting.
Abstract
This tutorial is focused on teaching PostgreSQL to professionals that are already experienced with Oracle or MySQL. As we discuss from basics, even a beginner may adapt the concepts easily. 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.
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
- Streaming replication
- Failover
Declarative Partitioning in PostgreSQL 11.
P.S. Slides Attached here are just prepared in a couple of hours. It will be much better by the day we present it.
- Date:
- 2019 March 18 09:00 EDT
- Duration:
- 7 h
- Room:
- Flatiron
- Conference:
- Postgres Conference
- Language:
- Track:
- Ops and Administration
- Difficulty:
- Medium