3 ms·
Did you know that Postgres has a max table size of 32TB? Its really really fun to find that out the Wednesday evening before Thanksgiving. Make sure to prune o
by kiernanmcgowan 3y ago
Did you know that Postgres has a max table size of 32TB? Its really really fun to find that out the Wednesday evening before Thanksgiving.
Make sure to prune old data from your tables. This one got to this limit because it eventually got too large that queries to delete old data would time out... so it just kept growing.
https://www.postgresql.org/docs/current/limits.html https://www.postgresql.org/docs/current/limits.html
- teaearlgraycold 3y agoI just put a maximum Postgres table size I’m willing to manage in my employment contract. By the time we’re measuring in Terabytes I’m out of there.
- drewda 3y agoFor an interesting presentation on Postgres at different orders of magnitude, all the way up to petabytes, see https://thebuild.com/presentations/2019-fosdem-broken.pdf https://thebuild.com/presentations/2019-fosdem-broken.pdf
- victorbjorklund 3y agoWow. That is still pretty large for one table.
- alex_127 3y agoit is partitioned underneath with limit of 32TB for single partition. (hello ctid). there could be many of them.