If you're generating terabytes of analytical data you should be using a different stack for analyzing that than you do for running your production workload.
(You could still use PostgreSQL, just not the same PostgreSQL servers that are running your user-facing features.)