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
Fabien Vauchelles
Scrapoxy
Katharina Fetzer
hylane GmbH
João Esperancinha
Vereniging COIN
Vadzim Prudnikau
Trainitek
Siddhant Agarwal
Neo4j
Vadzim Prudnikau
Trainitek
Daniel Raniz Raneland
factor10
Ambesh Singh
Visionet Systems Deutschland
Ambesh Singh
Visionet Systems Deutschland
Daniel Raniz Raneland
factor10
Opemipo Disu
Latitude
Federico Fregosi
OpsGuru
Shelly Goldblit
Dell Technologies
Sivan Biham
Healthy.io
Pradeep Sharma
Independent
Alexandre Gallice
Red Hat
Tech Internals Conf is the leading conference for developers of complex and highly loaded systems
Participation options
Offline
The price is soaring —> the closer the conference is, the more it costs.
The current price of a ticket is —> 360 EUR
If you have any questions you can reach out to our support service —> support@internals.tech
Special offer (from 5 tickets)
To order from 5 tickets, contact us support@internals.tech
leave a request
Changed your mind?
Please tell us why.
Thank you for your reply!
Become partner
Professional conference for developers of high-load systems