Managing a Spock Installation

The Spock extension is a powerful addition to any PostgreSQL installation; management features of the Spock extension allow you to seamlessly:

• replicate partitioned tables.
• use batch inserts to improve performance.
• create logical row-based data filters.
• set a cluster to READ-ONLY mode; this restricts non-superusers to read-only operations, while superusers can still perform both read and write operations.
• use a trigger to manage replication set membership.
• use Snowflake sequences for sequence management in a distributed cluster.
• enable automatic DDL replication.