Presented by:

078e68618ed6bbfefecb3e3500f9034e

Rushabh Lathia

from EnterpriseDB India Pvt. Ltd.
4d508cf0a9d460cf889a66583c303730

Dilip Kumar

from EnterpriseDB
No video of the event yet, sorry!

Checkout the slides

Handling customer escalations in PostgreSQL environments requires a deep understanding of performance bottlenecks, data integrity challenges, and replication conflicts. When critical issues such as subtransaction cache overflow, slow vacuum and wraparound risks, data corruption, and replication conflicts arise, they can lead to significant service disruptions, demanding swift and effective resolution. This talk will explore a structured approach to troubleshooting PostgreSQL escalations with real-world case studies.

Attendees will gain actionable insights into proactive monitoring, effective debugging methodologies, and best practices for preventing these PostgreSQL escalations before they impact production systems.

Date:
2025 March 6 - 10:45
Duration:
1 h
Room:
Neptune
Conference:
PGConf India, 2025
Language:
Track:
Sponsor Hall
Difficulty:
Easy

Happening at the same time:

  1. A lesser known Superpower of Postgres Logical Replication: Protocol Versions
  2. Start Time:
    2025 March 6 10:45

    Room:
    Grand Ballroom 1

  3. Understanding Write-Ahead Logging (WAL) in PostgreSQL
  4. Start Time:
    2025 March 6 10:45

    Room:
    Jupiter

  5. Performance is a feature: accelerating Postgres system performance with PL/Rust
  6. Start Time:
    2025 March 6 10:45

    Room:
    Grand Ballroom 2

  7. Hacking Postgres Executor For Performance
  8. Start Time:
    2025 March 6 11:30

    Room:
    Grand Ballroom 1

  9. How to Upgrade Replication Clusters without Downtime?
  10. Start Time:
    2025 March 6 11:30

    Room:
    Grand Ballroom 2

  11. Collation Challenges: Sorting it Out
  12. Start Time:
    2025 March 6 11:30

    Room:
    Jupiter