One point I might not have made clear. The reason I want to remove duplicates is that the column "data_object.unique_id" became non-unique (someone added duplicate rows). So I added the bigSeriel (idx) to uniquely identify the rows, and I was using the SELECT MIN(idx) and GroupBy to pick just one of the rows that became duplicated.
I am going to try out some of your excellent suggestions. I will report back on how they are working. -- View this message in context: http://postgis.17.n6.nabble.com/Slow-delete-of-duplicate-rows-tp4548251p4548659.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
