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

Reply via email to