News for hackers. Stuff that matters.
Re:Some opinionated thoughts on SQL databases by doteka on Wednesday March 31, 2021 @07:24AM (#26645865)
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.

Re:Some opinionated thoughts on SQL databases by sojournerc on Wednesday March 31, 2021 @08:58AM (#26646664)
If it's time series data check out the timescaledb extension.