On Tue, Jan 31, 2012 at 2:36 PM, Marc Mamin <m.ma...@intershop.de> wrote:
> But this raises an interesting question on how/where does Postgres store 
> statistics on functional indexes.
> in pg_statistics there are information on the column content, but I couldn't 
> find stats on the function result which is fully computed only during the 
> index creation.

Look for rows where starelid is equal to the OID of the index.

-- 
Robert Haas
EnterpriseDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company

-- 
Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-performance

Reply via email to