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.
- use the Lolor extension to replicate large objects.
- enable automatic DDL replication.