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@me3.com
me3 Technology Consultants, LLC
24 Preble Street, 2nd Floor
Portland, ME 04101
207-772-3217 (office)
207-838-8678 (mobile)
www.me3.com