The ideal case would be if you did something similar to what Timescale does with their compression/data tiering and kept "recent" data in a "regular" table so that transactional performance (including updates) is maximized but then "archive" it to columnar storage.
But also in general, how does `pg_analytics` compare to Timescale's compression or their tiered storage? My understanding is that compression is on disk and tiered storage is parquet files in S3.