git.osdn.net Git - pg-rex/syncrep.git/commit

author	Tom Lane <tgl@sss.pgh.pa.us>
	Thu, 20 Sep 2007 17:56:33 +0000 (17:56 +0000)
committer	Tom Lane <tgl@sss.pgh.pa.us>
	Thu, 20 Sep 2007 17:56:33 +0000 (17:56 +0000)
commit	282d2a03dd30804b01f8042f640d638c2ee76604
tree	004f08ce31f1bfb03ab55571ad7867babe5b3d7f	tree \| snapshot
parent	bbf4fdc2538097bb3103806e1419ceef1f289203	commit \| diff

HOT updates. When we update a tuple without changing any of its indexed
columns, and the new version can be stored on the same heap page, we no longer
generate extra index entries for the new version. Instead, index searches
follow the HOT-chain links to ensure they find the correct tuple version.

In addition, this patch introduces the ability to "prune" dead tuples on a
per-page basis, without having to do a complete VACUUM pass to recover space.
VACUUM is still needed to clean up dead index entries, however.

Pavan Deolasee, with help from a bunch of other people.

65 files changed:

contrib/pgstattuple/pgstattuple.c		diff \| blob \| history
doc/src/sgml/catalogs.sgml		diff \| blob \| history
doc/src/sgml/monitoring.sgml		diff \| blob \| history
doc/src/sgml/ref/create_index.sgml		diff \| blob \| history
src/backend/access/gin/ginentrypage.c		diff \| blob \| history
src/backend/access/gin/ginvacuum.c		diff \| blob \| history
src/backend/access/gin/ginxlog.c		diff \| blob \| history
src/backend/access/gist/gist.c		diff \| blob \| history
src/backend/access/gist/gistutil.c		diff \| blob \| history
src/backend/access/gist/gistvacuum.c		diff \| blob \| history
src/backend/access/hash/hashinsert.c		diff \| blob \| history
src/backend/access/hash/hashovfl.c		diff \| blob \| history
src/backend/access/hash/hashpage.c		diff \| blob \| history
src/backend/access/heap/Makefile		diff \| blob \| history
src/backend/access/heap/README.HOT	[new file with mode: 0644]	blob
src/backend/access/heap/heapam.c		diff \| blob \| history
src/backend/access/heap/hio.c		diff \| blob \| history
src/backend/access/heap/pruneheap.c	[new file with mode: 0644]	blob
src/backend/access/heap/rewriteheap.c		diff \| blob \| history
src/backend/access/index/genam.c		diff \| blob \| history
src/backend/access/index/indexam.c		diff \| blob \| history
src/backend/access/nbtree/nbtinsert.c		diff \| blob \| history
src/backend/access/nbtree/nbtsort.c		diff \| blob \| history
src/backend/access/nbtree/nbtxlog.c		diff \| blob \| history
src/backend/catalog/index.c		diff \| blob \| history
src/backend/catalog/indexing.c		diff \| blob \| history
src/backend/catalog/system_views.sql		diff \| blob \| history
src/backend/catalog/toasting.c		diff \| blob \| history
src/backend/commands/indexcmds.c		diff \| blob \| history
src/backend/commands/sequence.c		diff \| blob \| history
src/backend/commands/vacuum.c		diff \| blob \| history
src/backend/commands/vacuumlazy.c		diff \| blob \| history
src/backend/executor/execMain.c		diff \| blob \| history
src/backend/executor/execUtils.c		diff \| blob \| history
src/backend/executor/nodeBitmapHeapscan.c		diff \| blob \| history
src/backend/executor/spi.c		diff \| blob \| history
src/backend/nodes/tidbitmap.c		diff \| blob \| history
src/backend/optimizer/plan/planner.c		diff \| blob \| history
src/backend/optimizer/util/plancat.c		diff \| blob \| history
src/backend/optimizer/util/var.c		diff \| blob \| history
src/backend/postmaster/pgstat.c		diff \| blob \| history
src/backend/storage/buffer/bufmgr.c		diff \| blob \| history
src/backend/storage/page/bufpage.c		diff \| blob \| history
src/backend/utils/adt/pgstatfuncs.c		diff \| blob \| history
src/backend/utils/cache/plancache.c		diff \| blob \| history
src/backend/utils/cache/relcache.c		diff \| blob \| history
src/include/access/heapam.h		diff \| blob \| history
src/include/access/htup.h		diff \| blob \| history
src/include/access/relscan.h		diff \| blob \| history
src/include/catalog/catversion.h		diff \| blob \| history
src/include/catalog/pg_attribute.h		diff \| blob \| history
src/include/catalog/pg_index.h		diff \| blob \| history
src/include/catalog/pg_proc.h		diff \| blob \| history
src/include/nodes/execnodes.h		diff \| blob \| history
src/include/nodes/plannodes.h		diff \| blob \| history
src/include/nodes/relation.h		diff \| blob \| history
src/include/optimizer/var.h		diff \| blob \| history
src/include/pgstat.h		diff \| blob \| history
src/include/storage/bufmgr.h		diff \| blob \| history
src/include/storage/bufpage.h		diff \| blob \| history
src/include/utils/plancache.h		diff \| blob \| history
src/include/utils/rel.h		diff \| blob \| history
src/include/utils/relcache.h		diff \| blob \| history
src/test/regress/expected/create_index.out		diff \| blob \| history
src/test/regress/expected/rules.out		diff \| blob \| history

PostgreSQL9.0用の同期レプリケーションパッチ

RSS Atom

About OSDN

Find Software

Develop Software

Help