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.kla...@aklaver.com
