Postgres.AI bot interview for PGSQL Phriday #015
Pavlo Golub is interviewing postgres.ai chat bot about UUIDs for PGSQL Phriday 015 initiated by Lætitia Avrot
Unexpected downsides of UUID keys in PostgreSQL
There are various compelling reasons to use universally unique identifiers (UUID) as primary keys. Two examples are: To be able […]
UUID, serial or identity columns for PostgreSQL auto-generated primary keys?
by
Laurenz Albe |
05.2021 UPDATED 14.05.2022: Sometimes customers ask me about the best choice for auto-generated primary keys. In this article, I'll explore […]
int4 vs int8 vs uuid vs numeric performance on bigger joins
Brief overview of the performance of different datatypes on bigger joins. How much performance gets lost? Which one is better? Have a look!
