Greeitngs, * Ron (ronljohnsonjr@xxxxxxxxx) 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:
signature.asc
Description: PGP signature