v.22.6New Feature
New FPC Algorithm for Floating Point Data Compression
A new codec FPC algorithm for floating point data compression. #37553 (Mikhail Guzov).
Why it matters
The FPC codec provides efficient compression of floating point data, reducing storage space and potentially improving query performance by decreasing I/O operations when working with floating point columns.How to use it
To enable the FPC compression codec, specifyCODEC('FPC') in the table schema when creating or altering tables with floating point columns. For example:CREATE TABLE example (
value Float64 CODEC('FPC')
) ENGINE = MergeTree() ORDER BY tuple();