52.2. Distributed System Objects #

Distributed system has distributed objects, like tables, sequences, and tablespaces. It also has two other types of objects: pseudoglobal and regular.

Pseudoglobal objects are objects that don't have a global version, yet have the shardman.broadcast_ddl parameter enabled. In this case, these objects are created on all cluster nodes and can be used with other distributed objects (e.g. create a new schema).

Regular objects are other objects from PostgreSQL or Postgres Pro with no distributed features. Note that Postgres Pro Shardman does not use them in any cross-shard transactions. They can be used as a temporary solution throughout the migration from a non-distributed system.