Bring Compression to Postgres at Zero Cost of Performance
Автор: Postgres Conference
Загружено: 2021-07-29
Просмотров: 1012
This talk will present a solution that allows Postgres users to achieve significant data storage savings through compression at zero CPU/performance cost. The key is to deploy Postgres on new compression-capable solid-state drives (SSDs), which is developed following the current industry trend of empowering data storage devices with additional computing capability. This proposed talk will discuss and present: (1) the inefficiency and performance penalty inherent in current practice of realizing data compression for Postgres, which relies on either filesystems (e.g., ZFS and Btrfs) or Linux block layer (e.g., RedHat VDO), (2) introduction to commercially available SSDs with built-in hardware-based transparent compression, (3) experimental results that show, by replacing leading-edge commodity SSD with the new compression-capable SSD, one could reduce the storage cost by over 50% and meanwhile achieve the same or better Postgres TPS performance, and (4) experimental results that show, by deploying Postgres on the compression-capable SSD, one could largely reduce the fillfactor (e.g., from the default 100 to 75) at almost zero cost of physical storage capacity, while achieving over 2x higher TPS under update-intensive workloads. Finally, this proposed talk will discuss the potential of leveraging computation-capable SSDs to improve the efficiency of important operations (e.g., vacuum and table scan) in Postgres.
Доступные форматы для скачивания:
Скачать видео mp4
-
Информация по загрузке:
