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 The presenter has a unique opportunity to address hundreds of real-world, escalated issues from different users as part of the job. This gave a realisation that many are often running into a group of common mistakes. It will be of great value if PostgreSQL users can understand the mistakes well ahead and avoid them during the system design, development and deployment.

Content includes:

  1. Host machine / OS - Problems of poor tuning and remedies
  2. Problems during the upgrades and remedies
  3. High Availability - Myths and Facts.
  4. Synchronous replication - Myths, Facts and Problems people run into.
  5. Autovacuum tuning - How things can go really bad.
  6. Temporary tables in PostgreSQL - Understand the trap.
  7. Network latency - Performance killer, how to check.
  8. Indexes - They are not free. It can easily become a big burden unless used judiciously.
  9. Most common Parameter tuning mistakes are due to misunderstanding.
  10. Performance by design. - PostgreSQL concurrency

scripts/queries which can help users also will be shared.

Summary

This presentation can give an overall idea of common pitfalls. This should enable the audience to raise the Red flags as early as possible and avoid the minefield of common mistakes and associated troubles. This will be “A Practical Guide to Avoiding Disaster”

Date:
2024 March 1 - 12:20
Duration:
40 min
Room:
Robusta + Arabica
Conference:
PGConf India, 2024
Language:
Track:
Database Administration
Difficulty:
Medium

Happening at the same time:

  1. Various Isolation Levels in Relational Database Management Systems
  2. Start Time:
    2024 March 1 12:20

    Room:
    Grand Victoria B

  3. Unlocking financial DevOps: Navigating the FinOps landscape for cloud cost optimization in PostgreSQL
  4. Start Time:
    2024 March 1 12:20

    Room:
    Grand Victoria A