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 some compression 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 processed CDRs.
How about a second tablespace on a file system that compresses files?