Re: Yet another "drop table vs delete" question - Mailing list pgsql-general

From Thomas Finneid
Subject Re: Yet another "drop table vs delete" question
Date
Msg-id 49EF31F6.5040900@fcon.no
Whole thread Raw
In response to Re: Yet another "drop table vs delete" question  (Alvaro Herrera <alvherre@commandprompt.com>)
Responses Re: Yet another "drop table vs delete" question
List pgsql-general
Alvaro Herrera wrote:
> Try TRUNCATE.  That leaves the less garbage behind and takes the less
> time.

A follow up question, as far as I understand it, delete removes entries
in the fsm, so vacuum has to clean it all up when performing a delete,
is this approximately correct? what happens with truncate? does it
remove everything so that vacuum has almost no work to do or is it
approximately as much work either way?

regards

thomas


pgsql-general by date:

Previous
From: John Cheng
Date:
Subject: Re: What may cause - Connection rejected: FATAL: Ident authentication failed for user?
Next
From: S Arvind
Date:
Subject: Reg: Logging log_min_duration_statement