Re: Table/Parition Level Compression in Postgres

On Wed, 2022-02-16 at 18:10 +0530, Jagmohan Kaintura wrote:
> We have a requirement where we wanted to keep the partitions holding the old data into compressed
> format and the partition having the current data in the non-compressed format.
> While looking over the compression aspects in Pg 14 we have some compression introduced for the column level with
somecompression methods.
 
> Is there any other way using which we can compress the partitions data which can be even  moved to different
tablespace. 
> We have a implementation where we wanted to keep the 80% old data in the compressed format as we have millions of
processedCDRs.
 

How about a second tablespace on a file system that compresses files?

Yours,
Laurenz Albe
-- 
Cybertec | https://www.cybertec-postgresql.com