On Wed, 2003-02-26 at 15:54, Tom Lane wrote:
<snip>
>
> Comments anyone?
>
Now that indexes are getting some reporting, my understanding is an
index would report fewer pages overall than it's associated table, but
those pages would be completely empty. However, given that they don't
reported non-empty pages, the percentage of freeable space to total
space would be unfairly lower (if I'm right in thinking that the back
end will assume that non-reported pages don't have empty space in them).
This would tend to hurt index management even though it's pages are the
best candidates for removal (100% empty). Is this a valid concern, or am
I misreading something?
Robert Treat