Question : I’m working on a database design that extensively uses UUIDs for PRIMARY KEYs. However, this confronts me with […]
Guid vs. integer ID for unique fields
Question : This is really a generic question. Suppose I have a replication pattern of a single write DB and […]
`uuid_generate_v1mc` in Postgres “uuid-ossp” module: What is random multicast MAC address?
Question : The uuid-ossp module extension (plugin) for Postgres offers this alternative method for generating a UUID value. uuid_generate_v1mc() This […]
Cannot run ‘uuid-ossp’ functions even when it’s activated
Question : I want to generate a v4 uuid in PostgreSQL using the extension uuid-ossp, so in psql I ran: […]
How should I index a UUID in Postgres?
Question : I’m new to PostgreSQL and somewhat new to databases in general. Is there an established way of how […]
UUID/GUID field and shards
Question : I am planning on using UUID field for storing items which can have a parent item. I am […]
generate array of unique uuid in postgreSQL
Question : I would like to insert array of unique uuid values in table with uuid column as primary key. […]
best index type for uuid in postgres 11
Question : I realize a similar question has been asked multiple times but all the ones I can find are […]
How do I import CSV UUID data into Postgres on the command line?
Question : I’m using PostGres 10. I have this table > d myapp_currencyprice; Table “public.myapp_currencyprice” Column | Type | Modifiers […]
What concerns are there respect to use a short-UUID-like type as primary key?
Question : I’m thinking to use (on PostgreSQL v13) an UUID type (with uuid_generate_v4()) for my tables with high traffic, […]