| From: | "TJ O'Donnell" <tjo(at)acm(dot)org> |
|---|---|
| To: | <pgsql-general(at)postgresql(dot)org> |
| Cc: | <tjo(at)acm(dot)org> |
| Subject: | visualizing B-tree index coverage |
| Date: | 2005-01-25 22:19:17 |
| Message-ID: | 1383.209.223.166.104.1106691557.squirrel@gnova.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
Does anyone know of a tools that allows one to visualize
the tree created by a multi-column B-tree index?
A picture of a tree with branches, showing how "branchy" the
tree is would be great.
I'm wondering how well I've "clustered" the data in my table
using the multi-column index. In other words, do my
multi-columns sufficiently but not overly discriminate rows from each other?
Do I have too many with the same index? (not enough branches)
Do I have a unique index for each row? (way too many branches)
Thanks,
TJ
| From | Date | Subject | |
|---|---|---|---|
| Next Message | James Thompson | 2005-01-25 22:29:02 | Re: Data entry - forms design or other APIs etc. - what is there? |
| Previous Message | Michael Fuhr | 2005-01-25 22:15:01 | Re: Size of data stored in bytea record? |