truncate vs. delete

From: Emi Lu <emilu(at)encs(dot)concordia(dot)ca>
To: pgsql-sql(at)postgresql(dot)org
Subject: truncate vs. delete
Date: 2008-07-24 13:34:16
Message-ID: 488884D8.1070406@encs.concordia.ca
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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!

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Emi Lu 2008-07-24 13:47:48 Re: truncate vs. delete
Previous Message Anoop G 2008-07-24 12:56:50 postgres time zone settings