Zbigniew Baniewski <zb-pij/[EMAIL PROTECTED]> wrote:
In the docs there is a remark: "VACUUM only works on the main
database. It is not possible to VACUUM an attached database file".
I'm not sure: if one works with "attached" database, making a
"dbase-shot" of its contents to real database file, when ending the
work - does there exist any need to perform VACUUM?
The point of VACUUM is to reclaim pages freed by deleting records (or by
updating with less data, e.g. by removing large BLOBs). If you don't
modify the database, there's no reason to VACUUM it.
And of course, if you really want to, you can detach a database, open it
again directly, and vaccuum it on that new connection.
If I'm correct - attached database, when DETACH-ed, will be saved
into real database file "from the beginning to end", thus no
fragmentation there at all?
DETACH doesn't do any writing, it just disassociates a given connection
from a paricular DB file. I don't understand what you mean by "real"
database. Is there any other kind?
Igor Tandetnik
-----------------------------------------------------------------------------
To unsubscribe, send email to [EMAIL PROTECTED]
-----------------------------------------------------------------------------
