what happens to indexes when TRUNCATEing
От
Willy-Bas Loos
Тема
what happens to indexes when TRUNCATEing
Дата
Msg-id
1dd6057e0812170337r2c107c9etac56daec7a7d4cef@mail.gmail.com
Ответ на
Re: what happens to indexes when TRUNCATEing (Willy-Bas Loos)
Список
Дерево обсуждения
what happens to indexes when TRUNCATEing "Willy-Bas Loos" <willybas@gmail.com>
Re: what happens to indexes when TRUNCATEing Alvaro Herrera <alvherre@commandprompt.com>
Re: what happens to indexes when TRUNCATEing "Willy-Bas Loos" <willybas@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>
Re: 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>
Re: what happens to indexes when TRUNCATEing Alvaro Herrera <alvherre@alvh.no-ip.org>
>> What happens to indexes on a table that is TRUNCATEd?
"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
>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 по дате отправления
