Presented by:

F5403f688f5f147f0ad360734d5b3b00

Lalit Choudhary

from Percona

Worked on database technologies for more than 13+ years with various roles as DBA, QA, and Tester. Currently working with PERCONA as a Database Engineer for MySQL and PostgreSQL databases.

No video of the event yet, sorry!

Objective: From this topic, DBA should know how to approach if they are looking for testing, reproducing issues, Health checks, and monitoring for PostgreSQL.

Talk abstract:

  • Introduction: The significance of testing and monitoring tools and why DBA needs them. 
  • Obstacles: Testing environment Provisioning, Time-consuming, and Monetary cost.
  • Solution:  Utilizing opensource tools and virtualization options for quick setups and tests: Docker, Lxc, Vagrant, etc.
  • The best and fastest way to setup complex PostgreSQL setups like PostgreSQL replication, Patroni Cluster, and Kubernetes Operator environment for PostgreSQL using an opensource tool called  Anydbver(Developed and Maintained by Percona engineer) https://github.com/ihanick/anydbver 
  • Things to monitor for good performance,  Current vs. Historical data analysis
  • Monitoring Tools: pg_gather(https://github.com/jobinau/pg_gather), PMM  [with use cases and examples]

Date:
2024 March 1 - 11:35
Duration:
40 min
Room:
Grand Victoria B
Conference:
PGConf India, 2024
Language:
Track:
Database Administration
Difficulty:
Medium

Happening at the same time:

  1. PostgreSQL I/O Patterns
  2. Start Time:
    2024 March 1 11:35

    Room:
    Robusta + Arabica

  3. PostgreSQL 16: What's New? A comprehensive overview of the Latest Features
  4. Start Time:
    2024 March 1 11:35

    Room:
    Grand Victoria A