This is our case. A tiny staging environment will cause two tables to have billions of rows. This kills the Postgres. We are looking at moving this data out of

This is our case. A tiny staging environment will cause two tables to have billions of rows. This kills the Postgres. We are looking at moving this data out of the database and query it using Drill or similar. But if anyone has tips for handling huge tables in Postgres (yes, we partition already, this is a singe partition) I’m all ears.