.FILE 2G 3G 4G 5G

Seminar at Goto 10 in Malmö

Where do the performance cliffs come from?

24 Apr 2025, 17:30–20:00 | Organizer: Foo Café , PostgreSQL

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 examples 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 &
possible solutions proposed in recent research projects, focused on
making Postgres query execution more adaptive & robust.

Goto 10 är en arena där individer och organisationer kan dela kunskap, idéer och perspektiv. Detta event speglar arrangörens åsikter och delas inte nödvändigtvis av oss på Goto 10 och Internetstiftelsen. På Goto 10 får idéer och kunskap testas, diskuteras och utvecklas så länge de följer våra riktlinjer.

Fler event i Malmö