Postgres Pro
Downloads
Home   >   mailing lists

Re: TRUNCATE Question - Mailing list pgsql-general

From Tom Lane
Subject Re: TRUNCATE Question
Date
Msg-id 4274.1131589984@sss.pgh.pa.us
Whole thread Raw
In response to TRUNCATE Question  (Alex <alex@meerkatsoft.com>)
List pgsql-general
Tree view 
Alex <alex@meerkatsoft.com> writes:
> could anyone tell me if it is necessary to run a Vacuum after truncating
> a table or is that done automatically.

TRUNCATE does not require a vacuum; indeed there's nothing left *to* vacuum.

            regards, tom lane

pgsql-general by date:

Previous
From: Alex
Date:
Subject: TRUNCATE Question
Next
From: Michael Fuhr
Date:
Subject: Re: TRUNCATE Question