6 ms·
With random keys updates are going to touch way more pages than with sequential ones. It increases IO due to more dirty buffers and journaling.
by rapidlua 6y ago
With random keys updates are going to touch way more pages than with sequential ones. It increases IO due to more dirty buffers and journaling.
- tomsmeding 6y agoPoint taken. Quite true.
- Tostino 6y agoMore reading on this for Postgres: https://www.2ndquadrant.com/en/blog/sequential-uuid-generators/ https://www.2ndquadrant.com/en/blog/sequential-uuid-generato...