Page Comparison

SET search_path TO <tenantId>_mod_entities_links;
-- Find deleted records in authority table; index avoids two full table scans
CREATE INDEX IF NOT EXISTS authority_deleted_idx ON authority(deleted) WHERE deleted;
-- Move to archive
INSERT INTO authority_archive SELECT * FROM authority WHERE deleted = true ON CONFLICT DO NOTHING;
-- Delete deleted
DELETE FROM authority WHERE deleted = true;
-- Drop index
DROP INDEX authority_deleted_idx;