Schema management overview
Schemas in sharded databases require additional tooling and maintenance to work correctly. Most aspects of this are handled by PgDog automatically and documented below.
Schema manager
Tooling and automation for managing tables, indexes, primary keys, and other schema entities.
Migrations
Most applications use deterministic mechanisms for changing the database schema. PgDog sends DDL statements to all shards concurrently, ensuring table and index definitions are identical on all shards.
Primary keys
Primary keys are typically generated automatically by Postgres. We provide pl/PgSQL functions to make this work in sharded databases as well.