Database maintenance: Vacuum and reindex [1 day]

Ecotrust / cogs-priorities

national-scale refuge planning tool

Other

1 stars 1 forks source link

Open perrygeo opened 10 years ago

perrygeo commented 10 years ago

are they necessary on dataset load or will autovacuum handle it? Testing and if necessary automated deployment of appropriate commands on newdata.

perrygeo commented 10 years ago

need a pgpass file and run the vacuumdb --analyze command

perrygeo commented 10 years ago

REINDEX TABLE seak_planningunit;
REINDEX TABLE seak_puvsaux;
REINDEX TABLE seak_puvscf;
REINDEX TABLE seak_puvscost;
VACUUM ANALYZE;

perrygeo commented 10 years ago

May need to do a VACUUM FULL to reclaim disk space - disruptive so maybe run while precache is churning?