[kiernanmcgowan]

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

[teaearlgraycold]

I 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]

For 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

[alex_127]

it is partitioned underneath with limit of 32TB for single partition. (hello ctid). there could be many of them.

[victorbjorklund]

Wow. That is still pretty large for one table.