efficiency random values / sequential ID values in indexes

From: Sanjay Minni <sanjay(dot)minni(at)gmail(dot)com>
To: pgsql-general(at)lists(dot)postgresql(dot)org
Subject: efficiency random values / sequential ID values in indexes
Date: 2024-04-15 10:04:21
Message-ID: CAMpxBonz65-cqa_OUTvDYA9omPSMEAgqd6SrNDhWPzpOaJ5_rg@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi

Is there any appreciable difference in using random values or sequential
values in indexes

in a multi tenanted application there is a choice that the single field
ID's value is totally random / UUID or the numbers are created with a
prefix of the tenant. Since all access will be within a tenant only, will
it make any performance difference between using purely random values vs
<tenant no prefix part>+<random value>.

thanks
Sanjay

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Ron Johnson 2024-04-15 12:36:42 Re: Failing streaming replication on PostgreSQL 14
Previous Message Francisco Olarte 2024-04-15 08:24:55 Re: constant crashing