> >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
