Presented by:

80283b08e16ed6cd15579c06cb4fd8de

Sameer Kumar

from Amazon Web Services

Sameer Kumar is a Database Specialist at Amazon Web Services. He focuses on Amazon RDS, Amazon Aurora and Amazon DocumentDB. He works with enterprise customers providing technical assistance on database operational performance and sharing database best practices.

No video of the event yet, sorry!

If you run highly concurrent workload on PostgreSQL, you must have run into some or the other performance issues. Do you know PostgreSQL provides information on where are your queries spending their time via wait events in pg_stat_activity? You can poll pg_stat_activity view and identify what’s blocking a particular query. In this talk we will cover how you can use this information to identify top contributors to slowness in your workload. We will also talk about different categories of wait event and most common wait events that customers typically run into. We will talk about scenarios when these wait events block queries, how it affects your workload and how to mitigate them.

Date:
2023 February 23 - 14:00
Duration:
45 min
Room:
Robusta + Arabica
Conference:
PGConf India, 2023
Language:
Track:
Database Administration
Difficulty:
Medium

Happening at the same time:

  1. Journey of the DML queries
  2. Start Time:
    2023 February 23 14:00

    Room:
    Grand Victoria 1

  3. Deep dive of usage of Postgres in Zerodha and our learnings
  4. Start Time:
    2023 February 23 14:00

    Room:
    Grand Victoria 2