Chapter 6. Shardman Reference

Table of Contents

6.1. Functions

6.2. pgpro_stats Functions

6.3. Views

6.3.1. Global Views

6.3.2. shardman.pg_stat_csn

6.3.3. shardman.oldest_csn

6.3.4. shardman.pg_stat_monitor

6.3.5. shardman.pg_stat_netusage

6.3.6. shardman.pg_stat_foreign_stat_bytes

6.3.7. Multiplexor Diagnostics Views

6.4. SQL Commands

ALTER SEQUENCE — change the definition of a sequence generator

ALTER TABLE — change the definition of a table

CREATE SEQUENCE — define a new sequence generator

CREATE TABLE — define a new table

CREATE TABLESPACE — define a new tablespace

6.5. SQL Limitations

6.5.1. ALTER SYSTEM Limitations

6.5.2. ALTER TABLE Limitations

6.5.3. CREATE TABLE Limitations

6.5.4. DROP TABLE Limitations

6.5.5. CREATE INDEX CONCURRENTLY Limitations

6.5.6. UPDATE Limitations

6.5.7. INSERT ON CONFLICT DO UPDATE Limitations

6.5.8. Limitations of Managing Global Roles

6.5.9. ALTER SCHEMA Limitations

6.5.10. DROP SERVER Limitations

6.5.11. Limitations of Using Custom Databases

6.5.12. CREATE COLLATION Limitations

6.5.13. Logical Replication Limitations

6.5.14. Other Limitations

6.6. Shardman CLI Reference

shardmanctl — Shardman auxiliary command-line client and deployment tool

sdmspec.json — Shardman initialization file

shardmand — Shardman configuration daemon