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