News for hackers. Stuff that matters.

A comment on Amazon Aurora Limitless Database. Parent comment

Re:Amazon Aurora Limitless Database by kiernanmcgowan on Tuesday November 28, 2023 @12:11PM (#38448097)
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

[ Parent | on HN ]
Re:Amazon Aurora Limitless Database by teaearlgraycold on Tuesday November 28, 2023 @12:20PM (#38448200)
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.
[ Parent | on HN ]
Re:Amazon Aurora Limitless Database by drewda on Tuesday November 28, 2023 @12:29PM (#38448291)
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
[ Parent | on HN ]
Re:Amazon Aurora Limitless Database by victorbjorklund on Tuesday November 28, 2023 @03:47PM (#38451087)
Wow. That is still pretty large for one table.
[ Parent | on HN ]