UPDATE geonames SET location = ('(' || latitude || ', ' || longitude || ')')::point; DELETE FROM geonames WHERE latitude IS NULL or longitude IS NULL; -- DELETE 32 -- In my case, this ETL anomoly was too small -- to bother fixing the records -- Bloat removal...
UPDATE geonames SET location = ('(' || latitude || ', ' || longitude || ')')::point; DELETE FROM geonames WHERE latitude IS NULL or longitude IS NULL; -- DELETE 32 -- In my case, this ETL anomoly was too small -- to bother fixing the records -- Bloat removal from t...