[postgis-devel] spatial_ref_sys.sql

Kevin Neufeld kneufeld at refractions.net
Mon Feb 7 11:53:55 PST 2005


I noticed that the last line of spatial_ref_sys.sql in the postgis cvs 
head does a 'VACUUM ANALYZE;'. Since our postgis database is ~120GB, 
this takes a very long time. Consequently, we have cron jobs that do 
database maintenance at scheduled times. This last line should read, 
'VACUUM ANALYZE spatial_ref_sys';

-- 
Kevin Neufeld,
Refractions Research Inc.,
kneufeld at refractions.net
Phone: (250) 383-3022 
Fax:   (250) 383-2140 




More information about the postgis-devel mailing list