Thread: Does DROP TABLE free up disk space immediately?

Does DROP TABLE free up disk space immediately?

From
"Gabor Siklos"
Date:

Does DROP TABLE free up disk space immediately?

 

Thanks,

 

-Gabor



NOTE: The contents of this e-mail including any attachments may contain confidential or privileged information and are to be read solely by the intended recipient(s).  If you are not an intended recipient of this e-mail or have received this e-mail in error, please note that any dissemination, distribution, copying or retention of this e-mail without express permission is strictly prohibited.   If you believe that you received this e-mail in error, please notify the sender by return e-mail and then delete the message; do not read, save, forward or otherwise preserve or disseminate it.  The sender is unaware of any virus or similar defect that might affect a computer system on which this message or any attachment is opened, but MSD Capital does not assume liability by reason of sending this message for damages that may result from its access.  Please satisfy yourself as to the safety of any attachments before opening.

Re: Does DROP TABLE free up disk space immediately?

From
Alvaro Herrera
Date:
Gabor Siklos wrote:
> Does DROP TABLE free up disk space immediately?

It frees space at COMMIT.

--
Alvaro Herrera                                http://www.CommandPrompt.com/
The PostgreSQL Company - Command Prompt, Inc.