"kamil" <[EMAIL PROTECTED]> wrote: > I want to preallocate disk space for database. I have only one table with ~1 > milion entries, each entry takes about 30 bytes. Entries are added/removed > but there is some maximum number of items, which can be put into the table > at the same time. Is it possible to allocate a fixed disk space for such > database ?
Make sure autovacuum is turned off. Then insert 1M bogus entries and turn around and delete them. You are left with an empty database that is large enough to hold 1M entries without growing. -- D. Richard Hipp <[EMAIL PROTECTED]> ----------------------------------------------------------------------------- To unsubscribe, send email to [EMAIL PROTECTED] -----------------------------------------------------------------------------
