truncate vs. delete - Mailing list pgsql-sql

From Emi Lu
Subject truncate vs. delete
Date
Msg-id 488884D8.1070406@encs.concordia.ca
Whole thread Raw
Responses Re: truncate vs. delete
List pgsql-sql
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!




pgsql-sql by date:

Previous
From: "Anoop G"
Date:
Subject: postgres time zone settings
Next
From: Emi Lu
Date:
Subject: Re: truncate vs. delete