Another short post. Got self intersecting geometries? Want to fix them inside PostGIS? Me too. Fortunately, someone has already written the code, so you and I don’t have to:

http://linfiniti.com/2010/07/cleaning-geometries-inside-postgis/

Now, let’s see how long it takes to run on my 760,000 record landcover table… .