3 ms·
With how partitioning works in Postgres you could easily have millions of tables (even though they are just copies of a parent). I remember a company in Austin
by mrits 10y ago
With how partitioning works in Postgres you could easily have millions of tables (even though they are just copies of a parent). I remember a company in Austin writing a blog about how they delta which such a large catalog size Postgres.
We have about 200 tables that we partition by day. So in three years it's 200*300.