PGCon2016 - 20180510
PGCon 2016
The PostgreSQL Conference
| Speakers | |
|---|---|
|
Haribabu Kommi |
| Schedule | |
|---|---|
| Day | Talks - Day 1 - 2016-05-19 |
| Room | DMS 1120 |
| Start time | 10:00 |
| Duration | 00:45 |
| Info | |
| 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
- Different storage types and their relation
- Interaction with parallelism
- In-memory approach
- Performance comparison with other commericial databases
- Current state of the patch
- Further improvements