Thomas Kellerer <spam_eater(at)gmx(dot)net> wrote:
> I finally found a solution that runs fine:
>
> DELETE FROM dupes a
> WHERE EXISTS (SELECT 1
> FROM dupes b
> WHERE b.first_name = a.first_name
> AND b.last_name = a.last_name
> AND b.ctid > a.ctid);
How does performance for that compare to?:
CREATE TABLE nodupes AS
SELECT DISTINCT ON (last_name, first_name) * FROM dupes
ORDER BY last_name, first_name, ctid;
-Kevin