Re: local selectivity estimation - computing frequency of predicates

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



"Avdhoot Kishore Saple" <Avdhoot_Saple@xxxxxxxxxxx> 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


[Postgresql General]     [Postgresql PHP]     [PHP Users]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Yosemite]

  Powered by Linux