Product Documentation

Appearance

All platforms

SYSTEM_CLUSTER() ​

Return the name of the system cluster for an instance.

SYSTEM_CLUSTER()

For example:

yellowbrick=# select system_cluster();
   system_cluster 
--------------------
 eng-rc9-cluster-01
(1 row)

See also ALTER USER SET DEFAULT_CLUSTER and ALTER SYSTEM SET CLUSTER.

The system cluster is the default cluster for all system work, including automatic ANALYZE operations, flushing of rows from the row store, and "GC" operations. Only one cluster per instance can be the system cluster, and all system work runs against it.

When you create a cluster and specify WITH (DEFAULT_CLUSTER), this syntax implies that it is the system cluster, at least initially. Subsequently, you can change the system cluster as follows:

alter system set system_cluster "cluster_name"