Re: Compression In Postgresql 9.6

From: Kenneth Marshall <ktm(at)rice(dot)edu>
To: Ron <ronljohnsonjr(at)gmail(dot)com>
Cc: pgsql-general(at)lists(dot)postgresql(dot)org
Subject: Re: Compression In Postgresql 9.6
Date: 2019-08-05 13:27:18
Message-ID: 20190805132718.GF17132@aart.rice.edu
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

> >Hi,
> >
> >On RHEL/Centos you can use VDO filesystem compression to make an archive
> >tablespace to use for older data. That will compress everything.
>
> Doesn't this imply that either his table is partitioned or he
> regularly moves records from the main table to the archive table?
>

Hi,

Yes, he will need to do something to meet his goal of both a 100k TPS
and have older archives online. He could also use something like
postgres_fdw to have the archives on a seperate server completely.

Regards,
Ken

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Jeremy Finzel 2019-08-05 13:45:47 Aggregate not using BRIN index on timestamp
Previous Message Ron 2019-08-05 13:22:41 Re: Compression In Postgresql 9.6