I found a link for SQL Server, it applies to PostgreSQL 8.0.x as well?
http://vadivel.blogspot.com/2004/06/delete-vs-truncate-statement.html
Emi Lu wrote:
> Good morning,
>
> If I remember correctly, "delete" does not release space, while truncate
> will.
>
> I have an option now
>
> (1) Use object creator(with create/drop permission which I do not need
> in my cronjob script) to truncate table1(>100,000 recs) records
>
> (2) Use user1(has r/w only) to delete from table1, then vacuum it
>
> May I know how inefficient "delete from" comparing to truncate please?
>
> Thanks a lot!
>
>
>