TIL: relation size limit is 32 TiB in postgresql.org/docs/current/l
Not that I didn't know about it before. I saw it many times during my 17+ years of using Postgres. However, I never thought we'll reach it in near future.
Conversation
Does this change/increase with partitioning? (max 32 TiB per partition?)
2
3
That's right, max 32 TiB per partition
Nice, at terabyte (and petabyte) scale, you'd sure use partitioning anyway, so the practical limit for a partitioned table is much higher.
1
1
yes but large multi-TB relational databases are [generally] a recipe for finding the sharp edges. works but often requires expensive/expert staff. sharding across DBs can help orgs scale further before they have to cross the bridge #happinesshint
Quote Tweet
Latest PostgreSQL Happiness Hints: collection of things that I think every production PostgreSQL stack should have. Most things here are widely accepted, but a few are biased toward my opinions (eg scaling & dynamic conn pools). Mostly not original ideas; many people helped
Show this thread
