"Where do Performance Cliffs Come From?" with Tomas Vondra
Details
Join us virtually on Tuesday, April 8th for "Where do Performance Cliffs Come From?" with Tomas Vondra.
When running queries on a Postgres database, chances are you have
experience with hitting a "performance cliff" - an abrupt change of
performance for a given Postgres query, after only a small change in
data and/or query parameters.
In this talk, you'll learn why performance cliffs happen in Postgres.
After a brief explanation of how cost-based optimizers work and what
assumptions that relies on, I'll show a couple of examples of why/how it
fails. I'll also share recommendations on how to mitigate these
issues.
If time permits, I'll talk about a couple interesting improvements and
possible solutions proposed in recent research projects, focused
on making Postgres query execution more adaptive and robust.
Schedule:
12:00 PM Announcements, speaker introduction, presentation, Q&A.
1:15 PM Closing announcements, wrap up.
1:30 PM Event ends.
The link and detailed joining instructions, including the dial-in numbers for phone access, will be sent by email the day prior to the event, and posted on Meetup for those who have RSVPed "Yes".
General information about using GoToMeeting for this event can be found at:
"Where do Performance Cliffs Come From?" with Tomas Vondra