Changed the docs to explain more deeply how to set up the database more

[mir.git] / doc / MAINTENANCE

diff --git a/doc/MAINTENANCE b/doc/MAINTENANCE
index 0b1d2d3..907411a 100755 (executable)
--- a/doc/MAINTENANCE
+++ b/doc/MAINTENANCE
@@ -6,3 +6,12 @@ this generates a dir with all blobs and a sql-file with all data.
 To restore the database:
        psql <dbname> < <dbname>.sql
        pgdump_lo -i -d <dbname> -s /dumpdir/dir
+
+Every once in a while (or make a script) postgresql database should
+be "cleaned". See postgresql docs for commands VACUUM and VACUUM ANALYZE
+
+Every once in a while (or make a script) postgresql database should
+be "cleaned". See postgresql docs for commands VACUUM and VACUUM ANALYZE
+
+We also have misc. perl scripts to merge Large Objects from other DB's.
+these can be used as a basis to write your own custom scripts.