↑↓ select ↵ open ⌫ change scope Open full search

PG.CENTER connects PostgreSQL documentation, reference, and ecosystem knowledge. Maintained by Pigsty.

Feature: Reduced lock levels for ALTER TABLE commands

The following commands now have reduced lock levels for reduced lock contention:

VALIDATE CONSTRAINT

CLUSTER ON SET WITHOUT CLUSTER

ALTER COLUMN SET STATISTICS ALTER COLUMN SET () ALTER COLUMN RESET ()