Zbigniew Baniewski <zb-pij/[EMAIL PROTECTED]> wrote:
On Mon, Jan 21, 2008 at 10:43:39AM -0500, Igor Tandetnik wrote:
Now, if you expect the amount of data to grow in the future, it is
fine to leave free pages in. They will be reused as necessary. In
other words, you don't need to VACUUM if you are happy with your file
retaining the high water mark size (the size reflecting the largest
amount of data it ever held).
Thanks, that's I was afraid of: that there's something subtle, I'm
missing.
Another alternative is, rather than deleting just the data from the file
with DELETE FROM $table statements, to physically delete the whole file,
recreate the schema, then insert data from memory database. This way,
since you recreate the file from scratch each time, you won't need to
vaccuum.
Igor Tandetnik
-----------------------------------------------------------------------------
To unsubscribe, send email to [EMAIL PROTECTED]
-----------------------------------------------------------------------------
