The following query took only 16 hours 2 minutes
CREATE TABLE portal.new_metatdata AS
select distinct on (data_object.unique_id) * FROM portal.metadata;
Thank you.
--
View this message in context: http://postgresql.1045698.n5.nabble.com/Slow-duplicate-deletes-tp5537818p5544386.html
Sent from the PostgreSQL - novice mailing list archive at Nabble.com.