Hi Matt, On Fri, Jul 19, 2019 at 10:41:31AM -0400, Matthew Pounsett wrote: > On Fri, 19 Jul 2019 at 04:21, Luca Ferrari <fluca1978@xxxxxxxxx> wrote: > > > > > This could be trivial, but any chance you can partition the table > > and/or archive unused records (at least temporarly)? A 18 TB table > > quite frankly sounds a good candidate to contain records no one is > > interested in the near future. > > > > Partitioning is a possibility. The whole database is historical test > results, stored specifically for doing comparisons over time, so I'm not > sure we can actually archive anything. Expiring old test data is a > discussion we might have to have, eventually. > This is a case were using a compressed filesystem can give you space savings as well as faster read performance due to the compression factor. In my case a sequential scan of something in the compressed tablespace runs almost 3X faster than on the non-compressed one. Regards, Ken