projects / users / c2main / postgres.git / commit
? search:
summary | shortlog | log | commit | commitdiff | tree
(parent: 84d723b) | patch
Add the ability to store inheritance-tree statistics in pg_statistic,
authorTom Lane <tgl@sss.pgh.pa.us>
Tue, 29 Dec 2009 20:11:45 +0000 (20:11 +0000)
committerTom Lane <tgl@sss.pgh.pa.us>
Tue, 29 Dec 2009 20:11:45 +0000 (20:11 +0000)
commit649b5ec7c8a3050a30bd6d36003ba3a681c9a198
treeaf041b646426d71d9ea1113837b5f7a9001082c9tree
parent84d723b6cefcf25b8c800f8aa6cf3c9538a546b4commit | diff
Add the ability to store inheritance-tree statistics in pg_statistic,
and teach ANALYZE to compute such stats for tables that have subclasses.
Per my proposal of yesterday.

autovacuum still needs to be taught about running ANALYZE on parent tables
when their subclasses change, but the feature is useful even without that.
18 files changed:
doc/src/sgml/catalogs.sgml diff | blob | blame | history
src/backend/catalog/heap.c diff | blob | blame | history
src/backend/catalog/system_views.sql diff | blob | blame | history
src/backend/commands/analyze.c diff | blob | blame | history
src/backend/commands/vacuum.c diff | blob | blame | history
src/backend/executor/nodeHash.c diff | blob | blame | history
src/backend/nodes/copyfuncs.c diff | blob | blame | history
src/backend/nodes/outfuncs.c diff | blob | blame | history
src/backend/optimizer/plan/createplan.c diff | blob | blame | history
src/backend/utils/adt/selfuncs.c diff | blob | blame | history
src/backend/utils/cache/lsyscache.c diff | blob | blame | history
src/backend/utils/cache/syscache.c diff | blob | blame | history
src/include/catalog/catversion.h diff | blob | blame | history
src/include/catalog/indexing.h diff | blob | blame | history
src/include/catalog/pg_statistic.h diff | blob | blame | history
src/include/nodes/plannodes.h diff | blob | blame | history
src/include/utils/syscache.h diff | blob | blame | history
src/test/regress/expected/rules.out diff | blob | blame | history
Cedric's Stuff