Willy-Bas Loos escribió: > >> 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? Yes. -- Alvaro Herrera http://www.amazon.com/gp/registry/DXLWNGRJD34J "El sabio habla porque tiene algo que decir; el tonto, porque tiene que decir algo" (Platon). -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
