Tom, Guido

Thanks a lot for your suggestions. Now I understand perfectly what happens with
analyze, vacuum and toast areas. By the way, I used pgstattuple and I found it
was marvelous.

A last question: would you know any tool like pgstattuple but doing similar
things on indexes? I am particulary interested in how an index become
fragmented.If there is not, maybe I will dig into pgstattuple code and try to
figure out how could I do similar job on indexes.

Thanks again

Best regards

Eduardo Morelli

Search Discussions

Related Discussions

Discussion Navigation
viewthread | post
Discussion Overview
grouppgsql-novice @
postedJan 12, '06 at 8:19p
activeJan 12, '06 at 8:19p

1 user in discussion

Tmorelli: 1 post



site design / logo © 2022 Grokbase