News for hackers. Stuff that matters.
Re:PostgreSQL and UUID as Primary Key by masklinn on Friday July 05, 2024 @04:35PM (#40885761)
While Postgres does not cluster table, uuids do affect indexes significantly, random insertion causes increased index slack which translates to cache bloat and thus longer traversal and lower cache residency.

There are no comments on this comment yet.