PRODUCT | 产品中心 |
CSD OVERVIEW CSD 概观 APPLICATIONS 应用价值
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. See more at postgresql.org. 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. See more at postgresql.org.
DOWNLOADS 文件下载
CSD 2000 PostgreSQL App Brief CSD 2000 PostgreSQL App Brief
Jan 13th, 2020 Jan 13th, 2020
75% Lower Flash Cost! 75% Lower Flash Cost!
DRAMATIC TCO SAVINGS WITH PENALTY-FREE COMPRESSION 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

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 35% Better Performance
GAIN BENEFITS OF LOWER FILL FACTOR WITH NO DRAWBACKS 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.

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.