Re: UUID or auto-increment

From: Michael Lewis <mlewis(at)entrata(dot)com>
To: Ravi Krishna <srkrishna(at)yahoo(dot)com>
Cc: PostgreSQL General <pgsql-general(at)lists(dot)postgresql(dot)org>, pgsql-general <pgsql-general(at)postgresql(dot)org>
Subject: Re: UUID or auto-increment
Date: 2020-08-10 16:49:53
Message-ID: CAHOFxGrhDHScF2tot1YUVOF_oY7BPGU_+45ctJfFkxTeZ_j8Ug@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
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.

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Adrian Klaver 2020-08-10 16:51:29 Re: SQL Question about like
Previous Message Ron 2020-08-10 16:48:34 Re: SQL Question about like