| From: | Robert Haas <robertmhaas(at)gmail(dot)com> |
|---|---|
| To: | Marc Mamin <M(dot)Mamin(at)intershop(dot)de> |
| Cc: | Josh Berkus <josh(at)agliodbs(dot)com>, pgsql-performance(at)postgresql(dot)org |
| Subject: | Re: How to remove a table statistics ? |
| Date: | 2012-02-03 21:56:15 |
| Message-ID: | CA+Tgmobj8TiGvqyKm5tDfEDwRESPmF+5-=LVoKiApj_ZxJF_DA@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-performance |
On Tue, Jan 31, 2012 at 2:36 PM, Marc Mamin <M(dot)Mamin(at)intershop(dot)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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Cédric Villemain | 2012-02-04 16:04:29 | Re: wal_level=archive gives better performance than minimal - why? |
| Previous Message | Scott Marlowe | 2012-02-03 20:54:36 | Re: How to improve insert speed with index on text column |