Re: UUID or auto-increment

On 8/10/20 10:53 AM, Stephen Frost wrote:
> Greeitngs,
>
> * Ron (ronljohnsonjr(at)gmail(dot)com) wrote:
>> On 8/10/20 11:38 AM, Ravi Krishna wrote:
>>> Finally UUID results in write amplication in wal logs.  Keep that in mind
>>> if your app does lot of writes.
>>
>> Because UUID is 32 bytes, while SERIAL is 4 bytes?
>
> and because it's random and so will touch a lot more pages when you're
> using it...
>
> Avoid UUIDs if you can- map them to something more sensible internally
> if you have to deal with them.
>
> Thanks,
>
> Stephen
>
I suspect the increased storage cost is more related to the size of the
record than to the ratio of the data types.

What says two consecutively saved records ought to be stored on the same
page or will likely be sought with the same search criterion. Serial
ids put a time order (loosely) on the data which may be completely
artificial.