3 ms·
I once asked if Postgres would have any negative performance impact from holding 1.8m records and once the laughing stopped and they realized I was serious I go
by freehunter 8y ago
I once asked if Postgres would have any negative performance impact from holding 1.8m records and once the laughing stopped and they realized I was serious I got a good lesson on how robust Postgres can be.
- kod 8y agoI once worked for a company that maxed out a 32 bit autoincrement primary key on a mysql table. Relational databases can hold a lot more than people give them credit for.
- icedchai 8y agoYep. I worked at a company that had to migrate to 64-bit IDs. This was with MySQL 5.0 on servers with HDs, not SSD. Some of those "alter table" commands took all night!
- pickle-wizard 8y agoOh man, I hope they saw that one coming ahead of time.
- erik_seaberg 8y agoA colleague describes this problem as "running out of numbers".