PGConf NYC 2024: How to tune a slow Postgres query with pganalyze
Автор: pganalyze
Загружено: 2024-10-02
Просмотров: 1135
Описание:
In this session we walk through best practices of optimizing a slow query in Postgres, and how we can have a better mental model for how Postgres plans out a query, be it join order, index usage, or planner costing - and getting a sense for knowing when it goes wrong. We'll then discuss different ways of finding tuning opportunities for a given query, and how to benchmark them.
These approaches can be used on any Postgres database without additional tooling. Additionally we'll also discuss real world slow query examples and improve them using new query optimization features in pganalyze.
pganalyze enables your whole engineering team to tackle Postgres performance issues more effectively, and identify the root cause of slow queries.
Slides: https://postgresql.us/events/pgconfny...
#postgresql #postgres #queryoptimization
Повторяем попытку...
Доступные форматы для скачивания:
Скачать видео
-
Информация по загрузке:
