HybridDB for PostgreSQL which is a Greenplum-based engine that can support OLTP and OLAP in the same time, developed by Alibaba Cloud Database Team. We optimized the PostgreSQL's execution plan generator and DML executor for better OLAP performance, in the same hardware, the OLAP queries performance can be more than doubled.
In this session, We will introduce how we implement these optimizations.
I work as a Senior Database Engineer for Alibaba Cloud, focus on the performance optimization on HybridDB for PostgreSQL project. Prior to joining Alibaba, I was in IBM and Huawei, focus on query parallel execution project.