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. _______________________________________________ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users
