2013/2/17 Wellington <[email protected]>

> Pessoal,
>
> ha informacoes na internet, de que apos a versao 9 nao eh mais necessario
> executar o reindex database apos o vacuum full, mas nao encontrei nada na
> documentacao que confirmasse isso. Essa informacao procede?
>
>
Procede sim... veja o texto abaixo extraido de [1]:

"New implementation of VACUUM FULL. This command now rewrites the entire
table and indexes, rather than moving individual rows to compact space. It
is substantially faster in most cases, and no longer results in index
bloat."

Att,

[1] http://www.postgresql.org/docs/9.0/interactive/release-9-0.html

-- 
Fabrízio de Royes Mello
Consultoria/Coaching PostgreSQL
>> Blog sobre TI: http://fabriziomello.blogspot.com
>> Perfil Linkedin: http://br.linkedin.com/in/fabriziomello
>> Twitter: http://twitter.com/fabriziomello
_______________________________________________
pgbr-geral mailing list
[email protected]
https://listas.postgresql.org.br/cgi-bin/mailman/listinfo/pgbr-geral

Responder a