If I remember correctly, "delete" does not release space, while truncate
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
|Next:||From: Emi Lu||Date: 2008-07-24 13:47:48|
|Subject: Re: truncate vs. delete|
|Previous:||From: Anoop G||Date: 2008-07-24 12:56:50|
|Subject: postgres time zone settings|