3 ms·
And if you have a clustered index like in MS SQL Server, a non monotonic uuid results in inserting the data in the middle of the table (bad performance) rather
by cm2187 2y ago
And if you have a clustered index like in MS SQL Server, a non monotonic uuid results in inserting the data in the middle of the table (bad performance) rather than appending to the end.
- Tostino 2y agoFor the Postgres fans out there, it also kills performance on that side of the fence. You have things like wal amplification due to using things like UUID v4 (random prefix). I think v7 should greatly help with that.
- sgarland 2y agoIt also hurts query performance in some circumstances even in Postgres, due to the Visibility Map.