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

From Alvaro Herrera
Subject Re: what happens to indexes when TRUNCATEing
Date
Msg-id 20081217113917.GA4456@alvh.no-ip.org
Whole thread Raw
In response to what happens to indexes when TRUNCATEing  ("Willy-Bas Loos" <willybas@gmail.com>)
List pgsql-general
Willy-Bas Loos escribió:
> >> 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?

Yes.

--
Alvaro Herrera                 http://www.amazon.com/gp/registry/DXLWNGRJD34J
"El sabio habla porque tiene algo que decir;
el tonto, porque tiene que decir algo" (Platon).

pgsql-general by date:

Previous
From: "Willy-Bas Loos"
Date:
Subject: what happens to indexes when TRUNCATEing
Next
From: "Grzegorz Jaśkiewicz"
Date:
Subject: Re: what happens to indexes when TRUNCATEing