Обсуждение: Table/Parition Level Compression in Postgres
Hi Team,
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.
Best Regards,
Jagmohan
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
Hi Laurenz
Means that is what I am thinking even right now if we can move the partition to another tablespace and have file system level compression.
Apart from this do we have any other solution or strategy which I can try to implement?
On Wed, Feb 16, 2022 at 6:13 PM Laurenz Albe <laurenz.albe@cybertec.at> wrote:
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
Best Regards,
Jagmohan