zHeap: a new storage format
zHeap: a new storage format

Presented by:

D8b05d9945d2e74afbf8a26362671c00

Kuntal Ghosh

from Amazon Web Services

Kuntal Ghosh works as a software engineer at Amazon. He is working on various PostgreSQL research and development projects.

REPLACEMENT Please note that this talk replaces Timescale @ Zoomcar IOT stack
No video of the event yet, sorry!

Download slides

This talk will focus on zHeap which is a new storage format to avoid bloat due to PostgreSQL's MVCC mechanism while doing updates and deletes. When not handled efficiently, bloat is accumulated over time resulting in increase of table and index sizes although the amount of actual data remains unchanged and this directly affects the database performance.

Date:
2019 February 15 - 14:45
Duration:
45 min
Room:
Ballroom 4
Conference:
PGConf India, 2019
Language:
Track:
Database Engine Developer
Difficulty:
Expert

Happening at the same time:

  1. PostgreSQL Extensions: What exists and how to create a new one?
    2. Start Time:
    2019 February 15 14:45

    Room:
    Ballroom 3

  2. High availability and automatic failover in PostgreSQL on Kubernetes, On-premise and cloud using open source solutions.
    3. Start Time:
    2019 February 15 14:45

    Room:
    Ballroom 1