[postgis-users] Slow delete of duplicate rows

Paul Ramsey pramsey at opengeo.org
Wed Mar 7 08:29:28 PST 2012


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 <ygutfreund at 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 at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users



More information about the postgis-users mailing list