> * The database file itself contains one extra page for every
> (<page-size in bytes>/5) pages of data.
> * The worst case scenario for a database transaction is that
> all of these extra pages need to be journalled. So the journal
> file could contain all these extra pages.
Should also have mentioned that the number of extra pages is
the ceiling of (<num-pages>*(<page-size-in-bytes>/5)).
e.g. Assuming a page size of 1024 bytes, if you have 5 pages of
data your auto-vacuum database is 1 page bigger than the non-auto-vacuum
equivalent. If you have 210 pages of data, it's 2 pages bigger.
__________________________________
Do you Yahoo!?
Make Yahoo! your home page
http://www.yahoo.com/r/hs
