Re: what happens to indexes when TRUNCATEing

Поиск
Список
Период
Сортировка
От Willy-Bas Loos
Тема Re: what happens to indexes when TRUNCATEing
Дата
Msg-id 1dd6057e0812170336n6fc9ad2el3354ab9e482d0300@mail.gmail.com
обсуждение исходный текст
Ответ на Re: what happens to indexes when TRUNCATEing  (Alvaro Herrera <alvherre@commandprompt.com>)
Список 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 по дате отправления:

Предыдущее
От: "Grzegorz Jaśkiewicz"
Дата:
Сообщение: Re: what happens to indexes when TRUNCATEing
Следующее
От: Sam Mason
Дата:
Сообщение: Re: Isolating a record column from a PL-Pgsql function call ?