Re: deleting records from a table

From: Richard Broersma Jr <rabroersma(at)yahoo(dot)com>
To: Mario Behring <mariobehring(at)yahoo(dot)com>, pgsql-sql(at)postgresql(dot)org
Subject: Re: deleting records from a table
Date: 2007-01-12 17:53:33
Message-ID: 877653.1327.qm@web31803.mail.mud.yahoo.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql


---> 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.

In response to

Browse pgsql-sql by date

  From Date Subject
Next Message Richard Broersma Jr 2007-01-12 18:30:33 Re: deleting records from a table
Previous Message Mario Behring 2007-01-12 17:45:28 deleting records from a table