Postgres Pro Shardman 14.18.2 Documentation
				Next

Postgres Pro Shardman 14.18.2 Documentation

Postgres Professional

The PostgreSQL Global Development Group

Copyright © 2021-2025 Postgres Professional

Copyright © 1996-2025 The PostgreSQL Global Development Group

Table of Contents

1. Get Started with Shardman

1.1. What is Shardman
1.2. When to use
1.3. Quickstart Guide

2.1. Cluster Services
2.2. Scaling the Cluster
2.3. Rebalancing the Data
2.4. Analyzing and Vacuuming
2.5. Access Management
2.6. Backup and Recovery
2.7. Configuring Secure Communications with etcd
2.8. Upgrading a Cluster
2.9. Fault Tolerance and High Availability
2.10. Logging

3.1. Migration of a Database Schema
3.2. Data Migration
3.3. Queries
3.4. Connecting and Working with a Shardman Cluster

4. Additional Features

4.1. AQO (Adaptive Query Optimization)
4.2. CFS (Compressed File System)
4.3. pgpro_stats (Planning and Execution Statistics)
4.4. pgpro_pwr (Workload Reporting)
4.5. pg_query_state

5. Performance Tuning

5.1. Examining Plans
5.2. DML Optimizations
5.3. Time Synchronization
5.4. Distributed Query Diagnostics

6. Shardman Reference

6.1. Functions
6.2. pgpro_stats Functions
6.3. Advisory Lock Functions
6.4. Views
6.5. SQL Commands
6.6. SQL Limitations
6.7. Shardman CLI Reference

7. Shardman Internals

7.1. Table Types
7.2. Query Processing
7.3. Distributed Transactions
7.4. Silk
7.5. Distributed Deadlock Detection
7.6. Global Sequences
7.7. Syncpoints and Consistent Backup
7.8. Collecting Distributed Statement Statistics Using the pgpro_stats Extension
7.9. Advisory Locks

A. Release Notes

A.1. Postgres Pro Shardman 14.18.2
A.2. Postgres Pro Shardman 14.18.1
A.3. Postgres Pro Shardman 14.17.2
A.4. Postgres Pro Shardman 14.17.1
A.5. Postgres Pro Shardman 14.15.4
A.6. Postgres Pro Shardman 14.15.3
A.7. Postgres Pro Shardman 14.15.2
A.8. Postgres Pro Shardman 14.15.1
A.9. Postgres Pro Shardman 14.13.4
A.10. Postgres Pro Shardman 14.13.3
A.11. Postgres Pro Shardman 14.13.2
A.12. Postgres Pro Shardman 14.13.1
A.13. Postgres Pro Shardman 14.12.2
A.14. Postgres Pro Shardman 14.12.1
A.15. Postgres Pro Shardman 14.11.2
A.16. Postgres Pro Shardman 14.11.1
A.17. Postgres Pro Shardman 14.10.3
A.18. Postgres Pro Shardman 14.10.2

B. Glossary

C.1. General Questions
C.2. Databases
C.3. Tables
C.4. Sequences
C.5. User Management
C.6. Useful Functions and Tables
C.7. Disaster Recovery Cluster Requirements

		Next
		Chapter 1. Get Started with Shardman