Thomas Kellerer <spam_ea...@gmx.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
-- Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance
