efficiency random values / sequential ID values in indexes - Mailing list pgsql-general

From Sanjay Minni
Subject efficiency random values / sequential ID values in indexes
Date
Msg-id CAMpxBonz65-cqa_OUTvDYA9omPSMEAgqd6SrNDhWPzpOaJ5_rg@mail.gmail.com
Whole thread Raw
Responses Re: efficiency random values / sequential ID values in indexes  (Ron Johnson <ronljohnsonjr@gmail.com>)
List 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

 
  

pgsql-general by date:

Previous
From: Francisco Olarte
Date:
Subject: Re: constant crashing
Next
From: Ron Johnson
Date:
Subject: Re: Failing streaming replication on PostgreSQL 14