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? Yours, Laurenz Albe -- Cybertec | https://www.cybertec-postgresql.com
