Postgres Pro
Downloads
Home   >   mailing lists

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

From Ron
Subject Re: UUID or auto-increment
Date
Msg-id 2663a1f2-7377-58e7-ad7d-a867fe75cb15@gmail.com
Whole thread Raw
In response to Re: UUID or auto-increment  (Ravi Krishna <srkrishna@yahoo.com>)
Responses Re: UUID or auto-increment  (Stephen Frost <sfrost@snowman.net>)
Re: UUID or auto-increment  (Adrian Klaver <adrian.klaver@aklaver.com>)
List pgsql-general
Tree view
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?

--
Angular momentum makes the world go 'round.

pgsql-general by date:

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