Amit Kapila Robert Haas: zheap less bloat fewer writes and just plain smaller -- PGCon 2018
Channel: PGCon
Date: 2018-11-07

zheap: less bloat, fewer writes, and just plain smaller

To support MVCC, we always create a new version of a tuple on an update which must eventually be removed by periodic vacuuming or by HOT-pruning, but still in many cases space is never reclaimed completely. A similar problem occurs for tuples that are deleted. This leads to bloat in the database. In this talk, we will present a new storage format which will reduce the bloat, performs lesser disk writes and is smaller in size as compared to the current format.

https://www.pgcon.org/2018/