UUIDs vs Serial for Primary Keys - what's the right choice? #postgres #postgresql

preview_player
Показать описание

In 5mins of Postgres E59, you'll learn reasons for using random keys and for using sequential keys. We look at hybrid approaches (sequence + random or time + random) and are looking at UUIDv7.

*Learn more about pganalyze:*

*Check out the pganalyze library for eBooks, webinars, and more:*
  1. pganalyze
  2. Lukas Fittl
  3. pganalyze
  4. Christophe Pettus
  5. Brandur
  6. 2ndquadrant Postgres benchmark
Рекомендации по теме
5mins of Postgres 0:05:52

5mins of Postgres E59: UUIDs vs Serial for Primary Keys - what's the right choice?

UUID vs INT: 0:09:40

UUID vs INT: What’s Better For Your Primary Key?

UUIDs vs Serial 0:00:47

UUIDs vs Serial for Primary Keys - what's the right choice? #postgres #postgresql

Database Auto increment 0:07:09

Database Auto increment vs UUID - Which is Right for You?

3 reasons why 0:06:44

3 reasons why UUID is better than serial numbers

Auto increment vs 0:08:30

Auto increment vs UUID

Which is better? 0:00:49

Which is better? UUID or Int?

ULID vs UUID: 0:03:24

ULID vs UUID: Which One Should You Use?

Databases: Postgres uuid: 0:02:18

Databases: Postgres uuid: Use as primary key, or in addition to SERIAL -for disconnected app-

UUIDs are Bad 0:20:12

UUIDs are Bad for Performance in MySQL - Is Postgres better? Let us Discuss

How to generate 0:05:59

How to generate UUIDs as primary keys with Hibernate

The effect of 0:18:51

The effect of Random UUID on database performance

Stop Using UUID! 0:00:19

Stop Using UUID!

Understanding UUID in 0:07:20

Understanding UUID in 7 minutes

Better Than GUID 0:00:36

Better Than GUID - Have You Heard Of ULID Before? #shorts

SQL : MySQL 0:01:36

SQL : MySQL PRIMARY KEYs: UUID / GUID vs BIGINT (timestamp+random)

Databases: UUID or 0:01:59

Databases: UUID or BIGSERIAL Foreign Keys Postgres

#UUID Datatype #Primary 0:09:12

#UUID Datatype #Primary Key in #PostgreSQL Universally Unique Identifier

Can UUIDs collide 0:05:54

Can UUIDs collide with each other and how likely is that?

Удивительное и невероятное 0:51:10

Удивительное и невероятное о первичных ключах PostgreSQL: serial, bigserial, UUID v4, ULID, UUID v6...

5mins of Postgres 0:05:36

5mins of Postgres E10: max_wal_size, Postgres full page writes and UUID vs BIGINT primary keys

Using UUID as 0:10:45

Using UUID as a primary key for Spring Boot and Postgres database #tutorial

PostgresSQL: UUID As 0:10:45

PostgresSQL: UUID As Primary Keys | Course | 2019

How to partition 0:07:47

How to partition Postgres tables by timestamp based UUIDs