PGCon2016 - 20180510

PGCon 2016
The PostgreSQL Conference

Haribabu Kommi
Day Talks - Day 1 - 2016-05-19
Room DMS 1120
Start time 10:00
Duration 00:45
ID 919
Event type Lecture
Track Hacking
Language used for presentation English

In-memory column store

This presentation goes through the discussion of need of in-memory column store and approach to achieve it with different storage types and how it works for different SQL statements. And also, the interaction with parallelism for better performance and it's performance comparison with commercial databases based on the current prototype patch and its further improvements.

Following are the full details that will be discussed

  • Introduction
  • Need of column store
  • Need of in-memory
  • Overview of column store approach
    • Different storage types and their relation
      • Need of two different storages
      • Write optimized storage (WOS)
      • Read optimized storage (ROS)
    • Data movement from WOS to ROS
    • Need of Local ROS for select operation and how it works
    • write operations
    • Special handling for HOT updates
    • Handling of vacuum operation
  • Interaction with parallelism
  • In-memory approach
  • Performance comparison with other commericial databases
  • Current state of the patch
  • Further improvements