Horton

Re: UUID or auto-increment

Michael Lewis <mlewis@entrata.com>

View thread View on postgr.es
From: Michael Lewis <mlewis@entrata.com>
To: Ravi Krishna <srkrishna@yahoo.com>
Cc: PostgreSQL General <pgsql-general@lists.postgresql.org>, pgsql-general <pgsql-general@postgresql.org>
Date: 2020-08-10T16:49:53Z
Lists: pgsql-general 
UUID are also random and not correlated with time typically, so with a very
large table when accessing primarily recent data, hitting an index on a big
table will pull random pages into memory instead of primarily the end of
the index.