Conference Schedule - PGConf.EU 2018

zheap: An answer to PostgreSQL bloat woes

Date: 2018-10-24
Time: 16:20 - 17:10
Room: New York
Level: Intermediate

It is not a hidden fact that the PostgreSQL database can accumulate bloat over time. There are ways to contain it, but still in many cases space is never reclaimed completely. I will talk about the weakness of the current system due to which bloat happens and what are the possible strategies to reduce it.

The purpose of this talk is to present zheap, a new solution in development to reduce bloat. We will also discuss other advantages of zheap like:

  • The new storage format reduces write amplification both by avoiding rewrites of heap pages and by making it possible to do an update that touches indexed columns without updating every index.

  • The another major advantage of this project comes from the fact that it helps in reducing the size of the heap by (a) reducing tuple header size and (b) eliminating the need for aligning data in many cases.

This talk will also present some performance results which are based on the current state of this storage format. In the end, I will present the pros and cons of this new storage format.

Slides

The following slides have been made available for this session:

Speaker

Amit Kapila