Tuning PostgreSQL Performance with Wait Events, Sameer Kumar & Roneel Kumar | FOSSASIA Summit 2024

Описание: 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.

The 2024 edition of FOSSASIA PGDay will be held in Ha Noi, Vietnam from 8th to 9th April 2024. FOSSASIA PGDay 2024 is an excellent opportunity to learn more about PostgreSQL – the world’s most advanced open-source database. Get connected with like-minded people with an interest in PostgreSQL and open source software in the region. Learn more: https://2024.fossasia.org/pgday/

Session slides: https://eventyay.com/e/55d2a466/sessi...

#FOSSASIA #FOSSASIAPGDay #opensource #FOSS #sql #postgresql