what happens to indexes when TRUNCATEing

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

Предыдущее
От: "Dave Page"
Дата:
Сообщение: Re: A bit confused about Postgres Plus
Следующее
От: Alvaro Herrera
Дата:
Сообщение: Re: what happens to indexes when TRUNCATEing