@Paul_Wolfe What I’d recommend is that you move the old data to the correct RPs and then drop the old data.
Essentially what that means is
SELECT * INTO "db"."newrp"."newmeasurement" FROM "db"."oldrp"."oldmeasurement" GROUP BY *
Once you’re confident that you’ve moved all the data into the correct RP, I’d run
DROP RETENTION POLICY "oldrp" ON "db"
