Search Postgresql Archives
Re: UUID or auto-increment
[
Date Prev
][
Date Next
][
Thread Prev
][
Thread Next
][
Date Index
][
Thread Index
]
Subject
: Re: UUID or auto-increment
From
: Michael Lewis <mlewis@xxxxxxxxxxx>
Date
: Mon, 10 Aug 2020 10:49:53 -0600
Cc
: PostgreSQL General <pgsql-general@xxxxxxxxxxxxxxxxxxxx>, pgsql-general <pgsql-general@xxxxxxxxxxxxxx>
In-reply-to
: <
837516231.2607507.1597077490690@mail.yahoo.com
>
References
: <CAHaowgVasGvbuEBW4Fh-4ke31A9YfAF=VO5yk0OwS+0TT+azrw@mail.gmail.com> <
837516231.2607507.1597077490690@mail.yahoo.com
>
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.
[
Date Prev
][
Date Next
][
Thread Prev
][
Thread Next
][
Date Index
][
Thread Index
]
References
:
UUID or auto-increment
From:
Ashkar Dev
Re: UUID or auto-increment
From:
Ravi Krishna
Prev by Date:
Re: SQL Question about like
Next by Date:
Re: SQL Question about like
Previous by thread:
Re: UUID or auto-increment
Next by thread:
Re: UUID or auto-increment
Index(es):
Date
Thread
[Index of Archives]
[Postgresql Jobs]
[Postgresql Admin]
[Postgresql Performance]
[Linux Clusters]
[PHP Home]
[PHP on Windows]
[Kernel Newbies]
[PHP Classes]
[PHP Books]
[PHP Databases]
[Postgresql & PHP]
[Yosemite]
