git.postgresql.org Git - users/andresfreund/postgres.git/commit

projects / users / andresfreund / postgres.git / commit

author	Tom Lane <tgl@sss.pgh.pa.us>
	Tue, 29 Dec 2009 20:11:45 +0000 (20:11 +0000)
committer	Tom Lane <tgl@sss.pgh.pa.us>
	Tue, 29 Dec 2009 20:11:45 +0000 (20:11 +0000)
commit	0fac082d96746cc1e5ba3f1350c20df5298e6630
tree	8165dca5bcc01981d3abebd74d8d54fb7d1ff871	tree
parent	ca4556870d566cf0ddccdaa4b95e267e5dc623d1	commit \| 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

Andres' PG stuff

RSS Atom