Product

PostgreSQL is a free and open-source relational database management system (RDBMS) emphasizing extensibility and technical standards compliance. It is designed to handle a range of workloads, from single machines to data warehouses or Web services with many concurrent users.
REQUEST A POC
CSD 2000 Application Brief: PostgreSQL (CN)
MAR 06 / 2021 PDF

PostgreSQL

 

75% LOWER FLASH COST!

DRAMATIC TCO SAVINGS WITH PENALTY-FREE COMPRESSION

ScaleFux Computational Storage Drives (CSD) dramatically improve database cost efficiency, granting much lower $/bit versus NVMe SSDs.

PostgreSQL does not natively support data compression. For every one GB of ordinary SSD storage, users can store at most one GB of PostgreSQL data. However, the CSD 2000 compresses data on writes, allowing users to store up to 4x as much data, delivering a 75% reduction in storage cost. This improvement is even more dramatic when admins want to boost PostgreSQL performance by setting a lower Fill Factor.

CSD 2000 provides Penalty-Free Compression

  • Perform compression/decompression in the drive, without burdening the CPU and without adding Latency
  • Scale throughput with each drive and avoid CPU bottlenecks
  • Improve storage efficiency: lower cost to store each byte of data

 

35% BETTER PERFORMANCE

GAIN BENEFITS OF LOWER FILL FACTOR WITH NO DRAWBACKS

Fill Factor (FF) is the percent of each page that is filled with user data and can be configured to trade off storage cost and performance. Higher FF = slower but cheaper; Lower FF = faster but more expensive.

Storage Cost -- The default FF setting of 100% is optimized for storage cost efficiency. Reducing FF to 75%, PostgreSQL initially fills each 8KB page with 6KB of user data and 2KB of space reserved for future updates (Figure 2). The reserved space is filled with highly-compressible data (all zeros). Ordinarily, inserting reserved space directly increases storage footprint and cost.

Database Performance -- Lower FF yields better higher PostgreSQL performance (Figure 3). Our simulated TPC-C workload saw a 35% increase in QPS when Fill Factor was set to 75%.

CSD 2000 enables users to gain the QPS benefits of lower FF without incurring its traditional drawbacks, actually achieveing a 75-80% reduction in storage cost vs an ordinary SSD.