On Wed, Dec 17, 2008 at 11:37 AM, Willy-Bas Loos <willybas(at)gmail(dot)com> wrote:
>>> 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?
>
someone asked the same question here not so long time ago. The answer
is - yes, it applies to indices too.
--
GJ