Date: 2024-10-02
Time: 14:00–14:50
Room: Library (Sponsor)
Level: Beginner
Feedback: Leave feedback
In this session we'll 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.
The following slides have been made available for this session: