migrate public.users 20000 rows ORDER BY (account_id, updated_at, id) toYYYYMM(updated_at) note: sort key and partitioning cannot change after the table is created (PeerDB #4604): review them now note: needs REPLICA IDENTITY FULL: its sort key starts with account_id, and a DELETE (retention cleanup included) would otherwise leave the row live in ClickHouse postgres: ALTER TABLE "public"."users" REPLICA IDENTITY FULL postgres: CREATE PUBLICATION chlift_up_pub FOR TABLE "public"."users" wrote up.yaml: review it, then run `chlift migrate start`