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, [EMAIL PROTECTED]

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

Reply via email to