understanding pgstatindex

From: "Shlomi Marco" <shlomi(at)corp(dot)mocospace(dot)com>
To: <pgsql-general(at)postgresql(dot)org>
Subject: understanding pgstatindex
Date: 2007-09-19 08:26:10
Message-ID: 46f0dd31.06e9300a.0e22.18a0@mx.google.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hey all.

When running pgstatindex(some_index) I'm getting the usual result:

Version, tree_level, index_size, root_block_no, internal_pages, leaf_pages,
empty_pages, deleted_pages, avg_leaf_density, leaf_fragmentation

with a bunch of numbers.

Now, my question are

What each one represent (aside from the label), what exactly is "average
leaf density" or "leaf fragmentation" or any other label?

And even more importantly, how can I make sense out of this number regarding
my index?

I've been told that if "Leaf Frag" is above magic number, then reindex. But
I'm looking for a more empirical approach.

Intuitively, I assume that an index state depends on many params that are
somehow reflected by those number, and if I'll understand those, I could
understand my indexes state better.

Thanks.

Shlomi.

Browse pgsql-general by date

  From Date Subject
Next Message Shlomi Marco 2007-09-19 08:41:19 Understanding pgstatindex
Previous Message Dave Page 2007-09-19 08:00:34 Re: Version 8.2.5 for Windows doesn't startup normally after upgrading from 8.2.4