Deep dive into the postgres index types
from Mattermost Inc. (Spain)
About speaker
Principal Engineer at Mattermost
Jesús Espino is an Open-Source and software development enthusiast. He loves writing code and contributing to Open-Source projects.
About speakers company
Mattermost is an Open Source communication platform similar to Slack, focused on security and stability.
Abstracts
One of the critical parts of your SQL queries' performance is the index selection. If you are like most developers, you are probably using the default indexes on your databases, such as BTrees, which is usually a very safe option. But understanding the Index types, the internal representation, and why they are there can lead you to essential improvements in your query performance by changing or adding your indexes to get the better of them.
PostgreSQL supports multiple index formats. The most common one is the BTree, but there are also others like Hash, GiST, SP-GiST, GIN, and BRIN.
In this talk, we will explore each of them by explaining how the data is structured and how it helps to access the data quickly by showing an example of how the index is accessed by the queries.
After explaining the different indexes, I'll explain specific use cases where they are valuable and show some examples in a Postgres instance with data in it.
The Program Committee has not yet taken a decision on this talk
other talks of this topic
Opemipo Disu
Latitude
Mariia Bulycheva
Zalando
Sivan Biham
Healthy.io
Katharina Fetzer
hylane GmbH
Siddhant Agarwal
Neo4j
Alexandre Gallice
Red Hat
Fabien Vauchelles
Scrapoxy
Federico Fregosi
OpsGuru
Vadzim Prudnikau
Trainitek
Ambesh Singh
Visionet Systems Deutschland
Lara Mossler
Airbnb
Pradeep Sharma
Independent
Shelly Goldblit
Dell Technologies
Vadzim Prudnikau
Trainitek
Ambesh Singh
Visionet Systems Deutschland
Tech Internals Conf
is the largest conference for developers of complex
and highly loaded systems
Participation options
The price is soaring —> the closer the conference is, the more it costs.
what I`ll get?
- Participation in Q&A sessions
- Videos and slides after the conference
- Hearty coffee breaks and lunches
- Access to the exhibition area
- Afterparty with speakers and participants
Unlock up to 50%
off your ticket!
Enter your email to see your personalised discount — no commitment to purchase required
Changed your mind?
Please tell us why.
Thank you
for your reply!
Become partner
of the largest conference for developers of complex
and highly loaded systems