PG.CENTER connects PostgreSQL documentation, reference, and ecosystem knowledge. Maintained by Pigsty.
A logical replication subscriber can use indexes other than the PRIMARY KEY to perform lookups during UPDATE or DELETE operations,
PRIMARY KEY
UPDATE
DELETE