Goodbye Postgres Sequences, Hello Snowflake Sequences

Postgres Conference 2024

Overview

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.

Download a copy of the slides here.

Dive deeper into pgEdge

dive-img

How to Unleash Ultra High Availability and Zero Downtime Maintenance with Distributed PostgreSQL

dive-img

How Multi-Master Distributed Postgres Solves High Availability and Low Latency Challenges

dive-img

PostgreSQL 17 - A Major Step Forward in Performance, Logical Replication and More

Get started today.

Experience the magic of pgEdge Distributed PostgreSQL now.