pgsql: Adjust pgstat_initstats() to avoid repeated searches of the - Mailing list pgsql-committers

From tgl@postgresql.org (Tom Lane)
Subject pgsql: Adjust pgstat_initstats() to avoid repeated searches of the
Date
Msg-id 20070421041053.A5B279FA495@postgresql.org
Whole thread Raw
List pgsql-committers
Log Message:
-----------
Adjust pgstat_initstats() to avoid repeated searches of the TabStat arrays
when a relation is opened multiple times in the same transaction.  This is
particularly useful for system catalogs, which we may heap_open or index_open
many times in a transaction, and it doesn't really cost anything extra even
if the rel is touched but once.  Motivated by study of an example from Greg
Stark, in which pgstat_initstats() accounted for an unreasonably large
fraction of the runtime.

Modified Files:
--------------
    pgsql/src/backend/postmaster:
        pgstat.c (r1.152 -> r1.153)
        (http://developer.postgresql.org/cvsweb.cgi/pgsql/src/backend/postmaster/pgstat.c.diff?r1=1.152&r2=1.153)

pgsql-committers by date:

Previous
From: tgl@postgresql.org (Tom Lane)
Date:
Subject: pgsql: Tweak set_rel_width() to avoid redundant executions of
Next
From: tgl@postgresql.org (Tom Lane)
Date:
Subject: pgsql: Improve the way in which CatalogCacheComputeHashValue combines