Bet you could get it done even faster. Before you run the query, go set work_mem = '12GB';
then fire it off On Wed, Mar 7, 2012 at 7:11 AM, DrYSG <ygutfre...@draper.com> wrote: > 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 _______________________________________________ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users
