Schedule - pgDay Paris 2020
[x],[y],zheap - What is it good for?
Date: 2020-03-26
Time: 11:10–11:55
Room: Auditorium
Traditionally PostgreSQL stores relations in a format called heap. This comes with advantages, but also drawbacks. One of the downsides is, that every PostgreSQL DBA at some point in time needs to deal with bloat. zheap promises to mostly eliminate bloat but in addition claims to be better for certain kinds of workloads. In various demos we'll go through the architecture of zheap, highlight the advantages and then do some tests for comparing heap and zheap.