[postgis-users] Slow delete of duplicate rows

DrYSG ygutfreund at draper.com
Mon Mar 5 10:37:56 PST 2012


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.



More information about the postgis-users mailing list