Postgres Pro
Downloads
Home   >   mailing lists

Re: UUID or auto-increment - Mailing list pgsql-general

From Michael Lewis
Subject Re: UUID or auto-increment
Date
Msg-id CAHOFxGrhDHScF2tot1YUVOF_oY7BPGU_+45ctJfFkxTeZ_j8Ug@mail.gmail.com
Whole thread Raw
In response to Re: UUID or auto-increment  (Ravi Krishna <srkrishna@yahoo.com>)
List pgsql-general
Tree view
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.

pgsql-general by date:

Previous
From: Ron
Date:
Subject: Re: SQL Question about like
Next
From: Adrian Klaver
Date:
Subject: Re: SQL Question about like