[postgis-users] Slow delete of duplicate rows

[DrYSG]

I ran the query last night and it took only 16 hours and 2 minutes (Alienware
51, 8 cores, 24GB, raid disk, win7),



CREATE TABLE portal.new_metatdata AS
select distinct on (data_object.unique_id) * FROM portal.metadata; 

Thank you.

--
View this message in context: http://postgis.17.n6.nabble.com/Slow-delete-of-duplicate-rows-tp4548251p4554631.html
Sent from the PostGIS - User mailing list archive at Nabble.com.