pgsql: Improve handling of prune/no-prune decisions by storing a page's

From: tgl(at)postgresql(dot)org (Tom Lane)
To: pgsql-committers(at)postgresql(dot)org
Subject: pgsql: Improve handling of prune/no-prune decisions by storing a page's
Date: 2007-09-21 21:25:42
Message-ID: 20070921212542.C4AA5753E4C@cvs.postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-committers

Log Message:
-----------
Improve handling of prune/no-prune decisions by storing a page's oldest
unpruned XMAX in its header. At the cost of 4 bytes per page, this keeps us
from performing heap_page_prune when there's no chance of pruning anything.
Seems to be necessary per Heikki's preliminary performance testing.

Modified Files:
--------------
pgsql/contrib/pageinspect:
README.pageinspect (r1.2 -> r1.3)
(http://developer.postgresql.org/cvsweb.cgi/pgsql/contrib/pageinspect/README.pageinspect?r1=1.2&r2=1.3)
pageinspect.sql.in (r1.2 -> r1.3)
(http://developer.postgresql.org/cvsweb.cgi/pgsql/contrib/pageinspect/pageinspect.sql.in?r1=1.2&r2=1.3)
rawpage.c (r1.1 -> r1.2)
(http://developer.postgresql.org/cvsweb.cgi/pgsql/contrib/pageinspect/rawpage.c?r1=1.1&r2=1.2)
pgsql/doc/src/sgml:
storage.sgml (r1.18 -> r1.19)
(http://developer.postgresql.org/cvsweb.cgi/pgsql/doc/src/sgml/storage.sgml?r1=1.18&r2=1.19)
pgsql/src/backend/access/heap:
README.HOT (r1.1 -> r1.2)
(http://developer.postgresql.org/cvsweb.cgi/pgsql/src/backend/access/heap/README.HOT?r1=1.1&r2=1.2)
heapam.c (r1.241 -> r1.242)
(http://developer.postgresql.org/cvsweb.cgi/pgsql/src/backend/access/heap/heapam.c?r1=1.241&r2=1.242)
pruneheap.c (r1.1 -> r1.2)
(http://developer.postgresql.org/cvsweb.cgi/pgsql/src/backend/access/heap/pruneheap.c?r1=1.1&r2=1.2)
pgsql/src/backend/storage/page:
bufpage.c (r1.74 -> r1.75)
(http://developer.postgresql.org/cvsweb.cgi/pgsql/src/backend/storage/page/bufpage.c?r1=1.74&r2=1.75)
pgsql/src/include/catalog:
catversion.h (r1.426 -> r1.427)
(http://developer.postgresql.org/cvsweb.cgi/pgsql/src/include/catalog/catversion.h?r1=1.426&r2=1.427)
pgsql/src/include/storage:
bufpage.h (r1.74 -> r1.75)
(http://developer.postgresql.org/cvsweb.cgi/pgsql/src/include/storage/bufpage.h?r1=1.74&r2=1.75)

Browse pgsql-committers by date

  From Date Subject
Next Message Tom Lane 2007-09-21 22:52:52 pgsql: Fix regex, LIKE, and some other second-rank text-manipulation
Previous Message Tom Lane 2007-09-21 18:24:28 pgsql: Change tqual.c tests to use !TransactionIdIsCurrentTransactionId,