pgstatindex

[paulo matadr <saddoness@xxxxxxxxxxxx>]

Hi all,
I have been watching this  field (index_size) , and see probable bug on size .
anybody may explain me  how fix it?
 select * from pgstatindex('micromedicao.xfk8_consumo_historico');
 version | tree_level | index_size       | root_block_no | internal_pages | leaf_pages  | empty_pages | deleted_pages | avg_leaf_density | leaf_fragmentation
---------+------------+-------------+---------------+----------------+------------+-------------+---------------+------------------+--------------------
          2 |             3 | -1332748288 |         81517       |           1219     |     360379 |                   0 |                    0 |                 78.69 |              16.22

Size of xfk8_consumo_historico on database = 2825MB

one more dought about avg_leaf_density , what's this represent?


Thanks

---

Veja quais são os assuntos do momento no Yahoo! + Buscados: Top 10 - Celebridades - Música - Esportes