PostgreSQL 12 High Availability Cookbook - Third Edition

Getting ready

We will actually be starting from scratch in this recipe and will no longer use the pgbench tables. Instead, we want to start with new shell tables designed specifically for sharding. Execute the following SQL statements as the postgres user on an empty database to get ready:

CREATE SCHEMA myapp;
CREATE TABLE myapp.msg_log (
  id       SERIAL  PRIMARY KEY,
  message  TEXT    NOT NULL
);

We will be using this schema and table for the rest of this chapter.