| From: | Laurenz Albe <laurenz(dot)albe(at)cybertec(dot)at> |
|---|---|
| To: | Jagmohan Kaintura <jagmohan(at)tecorelabs(dot)com>, "pgsql-generallists(dot)postgresql(dot)org" <pgsql-general(at)lists(dot)postgresql(dot)org> |
| Subject: | Re: Table/Parition Level Compression in Postgres |
| Date: | 2022-02-16 12:43:39 |
| Message-ID: | 25630d5d4402b0eecf904c8f38be1d6e66d6f744.camel@cybertec.at |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Jagmohan Kaintura | 2022-02-16 12:46:30 | Re: Table/Parition Level Compression in Postgres |
| Previous Message | Jagmohan Kaintura | 2022-02-16 12:40:29 | Table/Parition Level Compression in Postgres |