projects
/
mir.git
/ commitdiff
commit
grep
author
committer
pickaxe
?
search:
re
summary
|
shortlog
|
log
|
commit
| commitdiff |
tree
raw
|
patch
|
inline
| side by side (parent:
4e42baf
)
postgresql vacuum / vacuum analyze
author
rk
<rk>
Mon, 11 Feb 2002 16:04:06 +0000
(16:04 +0000)
committer
rk
<rk>
Mon, 11 Feb 2002 16:04:06 +0000
(16:04 +0000)
doc/MAINTENANCE
patch
|
blob
|
history
diff --git
a/doc/MAINTENANCE
b/doc/MAINTENANCE
index
0b1d2d3
..
b0e2334
100755
(executable)
--- a/
doc/MAINTENANCE
+++ b/
doc/MAINTENANCE
@@
-6,3
+6,10
@@
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
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
+