| From: | paulo matadr <saddoness(at)yahoo(dot)com(dot)br> |
|---|---|
| To: | GENERAL <pgsql-general(at)postgresql(dot)org> |
| Subject: | pgstatindex |
| Date: | 2009-08-14 13:10:17 |
| Message-ID: | 209860.56549.qm@web52505.mail.re2.yahoo.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
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
http://br.maisbuscados.yahoo.com
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Sam Mason | 2009-08-14 14:00:47 | Re: adding a nullable col could rewrite the whole table? |
| Previous Message | Grzegorz Jaśkiewicz | 2009-08-14 12:42:58 | Re: Table as parameter |