4 ms·
UUID vs. BIGSERIAL for Primary Keys
- samcheng 11y agoEven if it is a hair slower, UUIDs (or similar schemes) are advantageous for reasons beyond being able to merge tables. Another big advantage is being able to use the UUID as a key, without worrying about exploits from guessing serial numbers: https://en.wikipedia.org/wiki/Predictable_serial_number_attack https://en.wikipedia.org/wiki/Predictable_serial_number_atta...