On Sep 30, 2005, at 8:21 AM, Douglas McNaught wrote:
so, what if simply dropping the table does not recover the disk-space?
It will. Each table is stored in its own set of disk files, and when
the table is dropped those files are simply deleted.
This is normally true. Vacuuming the database the table (or index) was
dropped from may free up disk space too.
Jim
-----
James Cradock, jcradock@xxxxxxx
me3 Technology Consultants, LLC
24 Preble Street, 2nd Floor
Portland, ME 04101
207-772-3217 (office)
207-838-8678 (mobile)
www.me3.com
---------------------------(end of broadcast)---------------------------
TIP 5: don't forget to increase your free space map settings
