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

From Stephen Frost
Subject Re: UUID or auto-increment
Date
Msg-id 20200810165332.GV29590@tamriel.snowman.net
Whole thread Raw
In response to Re: UUID or auto-increment  (Ron <ronljohnsonjr@gmail.com>)
Responses Re: UUID or auto-increment  (Israel Brewster <ijbrewster@alaska.edu>)
Re: UUID or auto-increment  (Rob Sargent <robjsargent@gmail.com>)
List pgsql-general
Greeitngs,

* Ron (ronljohnsonjr@gmail.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

Attachment

pgsql-general by date:

Previous
From: Ron
Date:
Subject: Re: UUID or auto-increment
Next
From: Adrian Klaver
Date:
Subject: Re: UUID or auto-increment