Postgres Pro
Downloads
Home   >   mailing lists

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

From Willy-Bas Loos
Subject what happens to indexes when TRUNCATEing
Date
Msg-id 1dd6057e0812170337r2c107c9etac56daec7a7d4cef@mail.gmail.com
Whole thread Raw
In response to what happens to indexes when TRUNCATEing  ("Willy-Bas Loos" <willybas@gmail.com>)
Responses Re: what happens to indexes when TRUNCATEing  ("Grzegorz Jaśkiewicz" <gryzman@gmail.com>)
List pgsql-general
Tree view
>> 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: "Dave Page"
Date:
Subject: Re: A bit confused about Postgres Plus
Next
From: Alvaro Herrera
Date:
Subject: Re: what happens to indexes when TRUNCATEing