Re: what happens to indexes when TRUNCATEing - Mailing list pgsql-general

From Willy-Bas Loos
Subject Re: what happens to indexes when TRUNCATEing
Date
Msg-id 1dd6057e0812170336n6fc9ad2el3354ab9e482d0300@mail.gmail.com
Whole thread Raw
In response to Re: what happens to indexes when TRUNCATEing  (Alvaro Herrera <alvherre@commandprompt.com>)
List pgsql-general
>> What happens to indexes on a table that is TRUNCATEd?
>They are truncated too.
From the manual:
"Furthermore, [truncate] reclaims disk space immediately, rather than requiring a subsequent VACUUM operation."
Does this go for indexes too?

Thx,

WBL

--
"Patriotism is the conviction that your country is superior to all others because you were born in it." -- George Bernard Shaw

pgsql-general by date:

Previous
From: "Grzegorz Jaśkiewicz"
Date:
Subject: Re: what happens to indexes when TRUNCATEing
Next
From: Sam Mason
Date:
Subject: Re: Isolating a record column from a PL-Pgsql function call ?