v.25.3New Feature
Add estimateCompressionRatio aggregate
Add estimateCompressionRatio aggregate function #70801. #76661 (Tariq Almawash).Why it matters
The function helps users evaluate how effectively data can be compressed in their tables. This insight can assist in storage planning and optimizing data layouts for improved performance and reduced disk usage.How to use it
Use the new aggregate functionestimateCompressionRatio within queries to calculate the estimated compression ratio of a dataset. For example:SELECT estimateCompressionRatio(column_name) FROM table_name;