PGCon2017 - 20180510

PGCon 2017
The PostgreSQL Conference

Amit Kapila
Day Talks - Day 1 - 2017-05-25
Room DMS 1120
Start time 14:00
Duration 00:45
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.