DELETE
FROM followers A USING followers B
WHERE A.user_id=B.user_id AND A.ts<=B.ts AND A.acct=B.acct AND A.ctid<B.ctid;
ALTER TABLE followers ADD UNIQUE (user_id, acct)