Re: UUID or auto-increment

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