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.jsonShardman initialization file
shardmand Shardman configuration daemon

The entries in this Reference are meant to provide in reasonable length an authoritative, complete, and formal summary about their respective subjects. More information about the use of Shardman, in narrative, tutorial, or example form, can be found in other parts of this book. See the cross-references listed on each reference page.