On Wed, Dec 17, 2008 at 11:37 AM, Willy-Bas Loos <willybas@xxxxxxxxx> 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 -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
