what happens to indexes when TRUNCATEing

From: "Willy-Bas Loos" <willybas(at)gmail(dot)com>
To: "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org>
Subject: what happens to indexes when TRUNCATEing
Date: 2008-12-17 11:37:18
Message-ID: 1dd6057e0812170337r2c107c9etac56daec7a7d4cef@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Alvaro Herrera 2008-12-17 11:39:17 Re: what happens to indexes when TRUNCATEing
Previous Message Willy-Bas Loos 2008-12-17 11:36:10 Re: what happens to indexes when TRUNCATEing