"Avdhoot Kishore Saple" <[EMAIL PROTECTED]> writes:
> How to compute the frequency of predicate (e.g. Salary > $70000) in an
> SQL query from a DB's pre-defined indexes?". I'm specifically looking at
> how to retrieve information about indices (like number of pages at each
> level of index, range of attribute values etc.)
I don't think what you're looking for is exposed anywhere. Postgres
doesn't rely on indexes for statistical information anyway; the
pg_statistic system catalog (see also pg_stats view) is used for that.
regards, tom lane
---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match
