First steps towards statistics on expressional (nee functional) indexes.
Tom Lane <tgl@sss.pgh.pa.us>
First steps towards statistics on expressional (nee functional) indexes. This commit teaches ANALYZE to store such stats in pg_statistic, but nothing is done yet about teaching the planner to use 'em. Also, repair longstanding oversight in separate ANALYZE command: it updated the pg_class.relpages and reltuples counts for the table proper, but not for indexes.
Files
| Path | Change | +/− |
|---|---|---|
| doc/src/sgml/catalogs.sgml | modified | +15 −6 |
| src/backend/catalog/heap.c | modified | +2 −3 |
| src/backend/catalog/index.c | modified | +14 −3 |
| src/backend/commands/analyze.c | modified | +323 −16 |
| src/backend/commands/tablecmds.c | modified | +13 −7 |
| src/include/catalog/heap.h | modified | +2 −1 |
| src/include/commands/vacuum.h | modified | +5 −2 |