Chapter 6. Shardman Reference
Prev	Up	Postgres Pro Shardman 14.15.2 Documentation	Home	Next

Chapter 6. Shardman Reference

Table of Contents

6.1. Functions

6.2. pgpro_stats Functions

6.3. Advisory Lock Functions

6.4. Views

6.4.1. Global Views
6.4.2. shardman.pg_stat_csn
6.4.3. shardman.pg_stat_xact_time
6.4.4. shardman.oldest_csn
6.4.5. shardman.pg_stat_monitor
6.4.6. shardman.pg_stat_netusage
6.4.7. shardman.pg_stat_foreign_stat_bytes
6.4.8. Multiplexor Diagnostics Views

6.5. 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.6. SQL Limitations

6.6.1. ALTER SYSTEM Limitations
6.6.2. ALTER TABLE Limitations
6.6.3. CREATE TABLE Limitations
6.6.4. DROP TABLE Limitations
6.6.5. CREATE INDEX CONCURRENTLY Limitations
6.6.6. UPDATE Limitations
6.6.7. INSERT ON CONFLICT DO UPDATE Limitations
6.6.8. Limitations of Managing Global Roles
6.6.9. ALTER SCHEMA Limitations
6.6.10. DROP SERVER Limitations
6.6.11. Limitations of Using Custom Databases
6.6.12. CREATE COLLATION Limitations
6.6.13. Logical Replication Limitations
6.6.14. Other Limitations

6.7. Shardman CLI Reference

shardmanctl — Shardman auxiliary command-line client and deployment tool
sdmspec.json — Shardman 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.

Prev	Up	Next
5.2. DML Optimizations	Home	6.1. Functions

pdf