On Tue, Jan 31, 2012 at 2:36 PM, Marc Mamin <M.Mamin@xxxxxxxxxxxx> 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@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance