Good bye sequences, hello Snowflakes
Presented by:
Jan Wieck
Jan Wieck is a former member of the PostgreSQL core team.
He designed and implemented Slony, overhauled the query rewrite rule system, wrote the procedural languages PL/pgSQL and PL/Tcl, added foreign keys, bgwriter, the statistics collector, the TOAST system and other features.
Sequences and serial columns have been a problem when it comes to logical database replication since the days of Slony-I. In this talk we take a look at different ways to avoid replicating sequences in the first place and how Snowflake IDs can help solve the problem, especially as we move to multi-master systems.
- Date:
- 2024 April 17 12:40 PDT
- Duration:
- 20 min
- Room:
- San Pedro
- Conference:
- Postgres Conference 2024
- Language:
- English
- Track:
- Ops
- Difficulty:
- Intermediate