Hybridpg: A Ssd-Friendly High Performance Hybrid Storage Design For Postgresql

Chunling Wang,Jiangtao Wang,Zhiliang Guo,Xiaofeng Meng
2014-01-01
Abstract:Flash-based solid state drives (SSDs) provide higher IOPS than disk drives. As a permanent data storage device, SSD exhibits more affordable prices than RAM. So we decide to use SSD as an extended cache for PostgreSQL to improve the performance of OLTP. In this demonstration, we mainly modify the shared buffer part of PostgreSQL and present a hybrid PostgreSQL based on SSD and HDD, called HybridPG. This demonstration can compare the performance between original PostgreSQL and HybridPG in TPC-C benchmark with different system parameters.
What problem does this paper attempt to address?