Columnar Table Performance Enhancements Of Greenplum Database, Xiaojian Fan ( Alibaba Cloud)

Приглашаем на конференцию HighLoad++ 2024, которая пройдет 2 и 3 декабря в Москве Программа, подробности и билеты по ссылке: HighLoad++ 2017 Тезисы: Alibaba built up a data warehouse service named HybridDB in its public cloud service, based on the open sourced Greenplum Database. And it keeps on enhancing HybridDB s preformance. This presentation will talk about how Alibaba improves HybridDB s performance for columnar tables with data block s meta data (MIN, MAX values of block data) and sort keys (predefined keys that data will be sorted and stored with). Testing result shows that, block metadata can be generated onthefly without much overhead, but can achive better performance even than index scan. With sort keys, a constant response time can be archived for GROUPBY and ORDERBY queries. Нашли ошибку в видео Пишите нам на