i set the auto vacuum option to enable. but my database size(hard-disk
space) still increased from 420MB to 440MB in 8 hours. most of the
operations in this database are the Select query command, just few
of Update or Insert.
why it can be increased so strongly?
after i executed the command
On Mon, Jun 04, 2007 at 04:15:12AM -0700, [EMAIL PROTECTED] wrote:
after i executed the command vaccumdb -f -z testdb, but the size
just decreased 1 or 2MB...
what's the problem?
vacuumdb -f does a FULL vacuum, which is blocking and compacts the
tables. If it only compacted 1 or 2 M, then