[GENERAL] Auto Vacuum question?

2007-06-07 Thread ivan . hou
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

Re: [GENERAL] Auto Vacuum question?

2007-06-07 Thread Andrew Sullivan
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