PGCon2017 - 20180510
PGCon 2017
The PostgreSQL Conference
| Speakers | |
|---|---|
|
Amit Kapila |
| Schedule | |
|---|---|
| Day | Talks - Day 1 - 2017-05-25 |
| Room | DMS 1120 |
| Start time | 14:00 |
| Duration | 00:45 |
| Info | |
| ID | 1039 |
| Event type | Lecture |
| Track | New Features |
| Language used for presentation | English |
Faster And Reliable Hash Indexes
PostgreSQL has supported Hash Index for a long time, but they are not much used in production mainly because they are not durable. In this talk, I will discuss the work done in PostgreSQL 10.0 to make it reliable and performant.
This paper will discuss the performance characteristics of Hash Indexes wherein we will see the performance improvements made in PostgreSQL 10.0. I will also share the performance comparison between Hash and Btree Indexes, both with respect to transactions per second and space-efficiency. I will also outline the cases where hash indexes can be used instead of btree indexes.
In this talk, I will discuss the write ahead logging for Hash Indexes, mainly focusing on challenges we have to overcome in doing so.
Finally, I will talk about the work that can be done to further improve it in terms of features, performance and space usage.