4 ms·
I can't wait until people find its limits!
by Agent766 3y ago
I can't wait until people find its limits!
- joelrwilliams1 3y agoI'm going to guess that Amazon.com will be one of the first to find all of the limits.
- amtamt 3y agoReminds of unbreakable linux.
- nusmella 3y agoI can't wait until people find its limits... in production!
- rilindo 3y agoProduction is the best testing environment after all.
- jimt1234 3y agoI don't always test my code. But when I do, I test it in production. -The Most Interesting Man in the World
- bob1029 3y agoFor 90%+ of our customers (small-to-mid sized US financial institutions), production is the only environment available to work with. For the other 10%, we take them aside and politely explain that they almost certainly have an unusable staging environment per the scope of our B2B project. Testing in production is a wonderful path if you are comfortable talking to business people and making lots of compromises.
- recursive 3y agoEveryone has a testing environment. Some people even have separate production environments.
- kiernanmcgowan 3y agoDid 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.