3 ms·
Vast majority of projects will not reach two billion row tables(ID>0), but it should be something considered when planning, and regularly revisited in the futur
by overcast 8y ago
Vast majority of projects will not reach two billion row tables(ID>0), but it should be something considered when planning, and regularly revisited in the future. BIGINT from the start uses twice as much space, if it's not needed, it's just a waste. You have to think about memory, indexing, scans in the future. Hundreds of millions of rows x 4 more bytes, is A LOT.