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

From Adrian Klaver
Subject Re: UUID or auto-increment
Date
Msg-id c1424aa1-0026-0613-dc17-906a1d674034@aklaver.com
Whole thread Raw
In response to Re: UUID or auto-increment  (Ron <ronljohnsonjr@gmail.com>)
List pgsql-general
On 8/10/20 9:51 AM, Ron wrote:
> On 8/10/20 11:38 AM, Ravi Krishna wrote:
> [snip]
>> 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?

You mean 32 digits for 128 bits?:

https://www.postgresql.org/docs/12/datatype-uuid.html

And there is BIGSERIAL which is 8 bytes.

> 
> -- 
> Angular momentum makes the world go 'round.


-- 
Adrian Klaver
adrian.klaver@aklaver.com



pgsql-general by date:

Previous
From: Stephen Frost
Date:
Subject: Re: UUID or auto-increment
Next
From: Michael Nolan
Date:
Subject: Re: SQL Question about like