Presented by:

  • Avinash Vallarapu (Avi) is currently working for Percona as a PostgreSQL Support Tech Lead. Before joining Percona, he worked for OpenSCG for 2.2 years as a Database Architect and for Dell as a Tech Lead for 9.8 Years. He has a vast experience in technologies like Oracle, PostgreSQL, MySQL and MongoDB. He is an avid Python and Golang developer. He has co-authored a book on PostgreSQL : Beginning PostgreSQL on Cloud and another book on MySQL is in progress.

  • He spoke at various PostgreSQL Conferences in the past including -

    • PGCONF India - 2017
    • PGCON 2018
    • Percona Live - PostgreSQL Track (2018) and
    • 2 talks for PGCONF 2019.
  • His areas of expertise are PostgreSQL Training, Consulting and Migrations.

No video of the event yet, sorry!
Download the Slides


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
Duration:
7 h
Room:
Flatiron
Conference:
Postgres Conference
Language:
Track:
Ops and Administration
Difficulty:
Medium