Search Postgresql Archives

Table/Parition Level Compression in Postgres

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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 

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]

  Powered by Linux