We're sorry but this page doesn't work properly without JavaScript enabled. Please enable it to continue.
Feedback

Postgres Meets Computational Storage

Formale Metadaten

Titel
Postgres Meets Computational Storage
Untertitel
Higher Performance at Lower Cost
Serientitel
Anzahl der Teile
637
Autor
Lizenz
CC-Namensnennung 2.0 Belgien:
Sie dürfen das Werk bzw. den Inhalt zu jedem legalen Zweck nutzen, verändern und in unveränderter oder veränderter Form vervielfältigen, verbreiten und öffentlich zugänglich machen, sofern Sie den Namen des Autors/Rechteinhabers in der von ihm festgelegten Weise nennen.
Identifikatoren
Herausgeber
Erscheinungsjahr
Sprache

Inhaltliche Metadaten

Fachgebiet
Genre
Abstract
This proposed talk will present how Postgres could seamlessly and significantly benefit from replacing normal solid-state drives (SSDs) with emerging computational storage drives (CSDs). Aligned with the grand trends towards heterogeneous and near-data computing, computational storage has gained tremendous momentum and led to an on-going industry-wide effort on expanding the NVMe standard to support CSD. The first generation CSD products have built-in transparent compression, which can be deployed into existing computing infrastructure without any changes to the OS and applications. This proposed talk will discuss and present: (1) brief introduction to commercially available CSDs with built-in transparent compression, (2) experimental results that show, by replacing leading-edge normal SSD with CSD, one could reduce the storage cost by over 50% and meanwhile achieve 30% better Postgres TPS performance, and (3) experimental results that show CSD could meanwhile significantly reduce the Postgres write amplification, which enables the use of emerging low-cost QLC flash memory to further reduce the system storage cost. Finally, this proposed talk will discuss the potential of leveraging CSDs to improve the efficiency of important operations in Postgres.