No. Extra space requirements relative to non-auto-vacuum databases 
are:

* 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.

Dan.

--- RexChan <[EMAIL PROTECTED]> wrote:
> Hi all,
> 
> In version 3.x, there is an autovacuum for free used space. What is the 
> maximum space for the autovacuum consumed?  For example, if one record 
> is deleted from 1000 records and the vacuum will be 
> automatically(autovacuum) operated, does the maximum used space for 
> autovacuum operation is equal to the size of the database file? Thanks!
> 
> Best regards,
> Kei
> 
> 


                
__________________________________ 
Do you Yahoo!? 
Yahoo! Sports - Sign up for Fantasy Baseball. 
http://baseball.fantasysports.yahoo.com/

Reply via email to