Re: what happens to indexes when TRUNCATEing

From: "Willy-Bas Loos" <willybas(at)gmail(dot)com>
To: "Alvaro Herrera" <alvherre(at)commandprompt(dot)com>
Subject: Re: what happens to indexes when TRUNCATEing
Date: 2008-12-17 11:36:10
Message-ID: 1dd6057e0812170336n6fc9ad2el3354ab9e482d0300@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 Willy-Bas Loos 2008-12-17 11:37:18 what happens to indexes when TRUNCATEing
Previous Message Dave Page 2008-12-17 11:26:00 Re: A bit confused about Postgres Plus