From: | Dirk Krautschick <Dirk(dot)Krautschick(at)trivadis(dot)com> |
---|---|
To: | "pgsql-general(at)lists(dot)postgresql(dot)org" <pgsql-general(at)lists(dot)postgresql(dot)org> |
Subject: | UUID with variable length |
Date: | 2020-10-15 20:49:49 |
Message-ID: | AM0PR05MB6082166783DBD33747A49417E9020@AM0PR05MB6082.eurprd05.prod.outlook.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Hi,
I have here a situation with the usage of UUID. Here the database user allows UUIDs with less then 16 byte lengths (please don't ask :-) ).
Of course there are some technical ways to do the filling of the not used bytes but I hope there is a better solution. This UUID is used
as primary Key and for indexing.
CHAR 16 is not preferred because of the risk of mistakenly changing the binary data.
Another option would be e.g. bytea but how is good would it work from a IO an latency perspective.
Or do you have some other ideas how to use a primary key datatype like UUID but with variable length?
Thanks
Dirk
From | Date | Subject | |
---|---|---|---|
Next Message | Dirk Krautschick | 2020-10-15 20:58:13 | Date Format 9999-12-31-00.00.00.000000 |
Previous Message | Raj Iyer | 2020-10-15 17:22:51 | Question on postgres certified OS platforms |