Presented by:

6df438f4ad107c2f1b5fb3d93a374d59

Yugank Srivastava

from Brightly
No video of the event yet, sorry!

AI-Assisted Post-Mortem Analysis and Optimizations for PostgreSQL Performance

Abstract For database administrators (DBAs), resolving PostgreSQL performance issues is a time-sensitive task that traditionally relies on manual log reviews and system analysis. This paper presents a concise approach to using AI for post-mortem analysis, enabling faster identification of failure patterns and root causes based on historical data. AI algorithms can detect inefficiencies in queries, resource usage, and configurations that might be missed in manual assessments. Additionally, AI can predict potential bottlenecks by analyzing past trends, allowing DBAs to implement preventive measures proactively. This AI-driven solution streamlines database management, reduces downtime, and optimizes PostgreSQL performance, providing DBAs with a powerful tool for efficient database operations.

Date:
2025 March 7 - 14:00
Duration:
45 min
Room:
Grand Ballroom 1
Conference:
PGConf India, 2025
Language:
Track:
Database Administration
Difficulty:
Medium

Happening at the same time:

  1. Accelerating PL/pgSQL Code Conversion on Migration from Another Database
  2. Start Time:
    2025 March 7 14:00

    Room:
    Grand Ballroom 2

  3. Harnessing GIS capability of PostgreSql using POSTGIS and OpenStreetMap (OSM) DATA
  4. Start Time:
    2025 March 7 14:00

    Room:
    Jupiter