Eduardo Morelli,  José Maria Monteiro,  Ana Carolina Almeida,  Sérgio Lifschitz. 

We propose a solution to the automatic and online reindex problem. The proposed mechanism runs continuously and with almost no human intervention. The adopted strategy is based on ad-hoc heuristics that monitor the index fragmentation level and, when necessary, reindex it automatically. We have actually implemented our ideas within the PostgreSQL DBMS code. Practical performance tests show the effectiveness of our approach.

http://www.lbd.dcc.ufmg.br:8080/colecoes/sbbd/2009/003.pdf

Processando consulta.