Introduction to PostgreSQL for MySQL and Oracle DBAs

Monday 9:00AM - 12:00PM

@ Showroom

PostgreSQLOpen Source Databases

3 hours tutorial

Intermediate

Tracks:
Tutorial, Operations

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
Streaming replication


Speakers

Avinash Vallarapu

Avinash Vallarapu (Percona)

PostgreSQL Support Tech Lead

Biography:

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.


Slides



  Download Slides  

Connect with Percona

Stay Connected on:

Percona Live Conferences

The Percona Live Open Source Database Conferences are the premier event for the diverse and active open source database community, as well as businesses that develop and use open source database software.
 

Contact Us

For general information about the event/expo/conference, including registration, please contact us at:

  • info(@) percona.com
  • +1-888-401-3401
  • +1-919-948-2863