[postgis-users] Slow delete of duplicate rows

DrYSG ygutfreund at draper.com
Wed Mar 7 07:11:09 PST 2012

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.

More information about the postgis-users mailing list