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

Postgres Live: Monthly Series Scaling PostgreSQL: Vertical, Horizontal, and High Availability Strategies

dive-img

Introducing The pgEdge Postgres MCP Server - And How to Connect it to Claude Code and Cursor

dive-img

RAG Servers vs MCP Servers: Choosing the Right Approach for AI-Powered Database Access

Get started today.

Experience the magic of pgEdge for non-distributed and distributed Postgres deployments.