Postgres Pro
Downloads
Home   >   mailing lists

Re: deleting records from a table - Mailing list pgsql-sql

From Richard Broersma Jr
Subject Re: deleting records from a table
Date
Msg-id 877653.1327.qm@web31803.mail.mud.yahoo.com
Whole thread Raw
In response to deleting records from a table  (Mario Behring <mariobehring@yahoo.com>)
List pgsql-sql
Tree view 
---> Simple question: once I execute the delete statement, does it free disk space immediatelly?
No.  deleted rows (in a sense) are simply marked as deleted and are made avaliable for being
written over by a new or updated tuple.  If you want to recover the space you can you TRUNCATE or
VACUUM FULL & possible REINDEX.

Regards,
Richard Broersma Jr.

pgsql-sql by date:

Previous
From: Mario Behring
Date:
Subject: deleting records from a table
Next
From: Richard Broersma Jr
Date:
Subject: Re: deleting records from a table