Presented by:

1f7511c5daf28a6d1a3519a086e67de3

Jobin Augustine

from Percona

Jobin Augustine is a PostgreSQL expert and Open Source advocate and has more than 21 years of working experience as a consultant, Architect, administrator, writer, and trainer in PostgreSQL, Oracle and other database technologies. He has always been an active participant in the Open Source communities, and his main focus area is database performance and optimization. He is a contributor to various Open Source Projects, an active blogger and loves coding in C++ and Python. Jobin holds a Masters in Computer Applications and joined Percona in 2018. Previously, he worked at OpenSCG for two years as Architect and was part of the BigSQL core team. Jobin worked at Dell as Database Senior Advisor for ten years and five years with TCS/CMC.

Speaker at many conferences
PGConf India, Almost every year till 2020
postgresconf 2019
PerconaLive 2019
pgconf.Eu 2019

Checkout the slides

Introduction.

Have you ever been in a database emergency and needed real quick pinpointing information on what is wrong with a PostgreSQL instance/database?
Are you looking for a good Analysis and meaningful conclusions using the data presented by PostgreSQL performance views (pg_stat_*)
Have you ever felt that there is too much performance and monitoring data and how to make sense of that?
If the answer is "Yes" for any or all of these. This is a presentation for you.
Content primarily targeted for DBAs and Support Engineers who need to deal with operational emergencies frequently. Understanding frequent issues will be helpful for designers and architects.

Contents

  • Most Important information the PostgreSQL stats views give us is their indications.
  • How to effectively utilize the wait-event information to understand the problems and performance bottlenecks
  • How to analyze database-level information How to analyze table and Index information
  • How to check autovacuum efficiency? What are the practical problems with autovacuum tuning?
  • Make meaningful ideas about table and index information.
  • Explaining major problems encountered by many users
  • identification of indicators of poor tuning practice.
  • What data we need to collect
  • Data from Host OS and how to correlate.

This presentation also includes Sharing of Simple scripts and methods for data collection and analysis. I will be sharing some of the best practices, also.

Date:
2023 February 24 - 11:15
Duration:
45 min
Room:
Robusta + Arabica
Conference:
PGConf India, 2023
Language:
Track:
Database Administration
Difficulty:
Easy

Happening at the same time:

  1. Internals of logical replication
  2. Start Time:
    2023 February 24 11:15

    Room:
    Grand Victoria 1

  3. Writing Your Server-Side Functions in any language
  4. Start Time:
    2023 February 24 11:15

    Room:
    Grand Victoria 2