On Mon, Jan 21, 2008 at 09:59:08AM -0500, Igor Tandetnik wrote:
> 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?
Perhaps I had false idea on what's going on, when working with attached
database. If I properly understood, in such case all the operations are
taking place directly in memory, and when DETACH-ing such database, only
then the "in-memory" database contents is written to physical database file
(if you don't like "real"), the one on the disk.
If it's working the way described above - it seems to me, that the physical
file is always entirely overwritten with the memory contents (when detaching).
So, it's never fragmented. And in conclusion: there's no need for VACUUM.
But I'm not sure, about the above... is it really working the way, I'm
supposing - or I'm wrong about it?
--
pozdrawiam / regards
Zbigniew Baniewski
-----------------------------------------------------------------------------
To unsubscribe, send email to [EMAIL PROTECTED]
-----------------------------------------------------------------------------
