💾 Archived View for gemini.bortzmeyer.org › fosdem › event-11138.gmi captured on 2023-03-21 at 00:57:18. Gemini links have been rewritten to link to archived content
⬅️ Previous capture (2021-12-17)
-=-=-=-=-=-=-
Tomasz Gintowt
Type devroom
Starts on day 2 (2021-02-07) at 13:30 (Brussels time, UTC+1) in room Postgresql (duration 00:30)
Matrix room #postgresql:fosdem.org
In this talk, I would like to share the successful experience how to improve index search performance. All of us uses indexes, it's one of the first features that we learns starting our journey with databases. Index on the right column can significantly improve query. Can we do anything more than just run CREATE INDEX ? This talk will explain how in easy way we can improve exists indexes, we will look into pg_stat and EXPLAIN output.