Skip site navigation (1) Skip section navigation (2)

pgsql: Modify AtEOXact_CatCache and AtEOXact_RelationCache to assume

From: tgl(at)svr1(dot)postgresql(dot)org (Tom Lane)
To: pgsql-committers(at)postgresql(dot)org
Subject: pgsql: Modify AtEOXact_CatCache and AtEOXact_RelationCache to assume
Date: 2005-08-08 19:17:24
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-committers
Log Message:
Modify AtEOXact_CatCache and AtEOXact_RelationCache to assume that the
ResourceOwner mechanism already released all reference counts for the
cache entries; therefore, we do not need to scan the catcache or relcache
at transaction end, unless we want to do it as a debugging crosscheck.
Do the crosscheck only in Assert mode.  This is the same logic we had
previously installed in AtEOXact_Buffers to avoid overhead with large
numbers of shared buffers.  I thought it'd be a good idea to do it here
too, in view of Kari Lavikka's recent report showing a real-world case
where AtEOXact_CatCache is taking a significant fraction of runtime.

Modified Files:
        xact.c (r1.211 -> r1.212)
        catcache.c (r1.121 -> r1.122)
        relcache.c (r1.225 -> r1.226)
        resowner.c (r1.12 -> r1.13)

pgsql-committers by date

Next:From: Tom LaneDate: 2005-08-08 19:44:23
Subject: pgsql: Avoid useless loop overhead in AtEOXact routines when the backend
Previous:From: User NwakefieldDate: 2005-08-08 18:18:34
Subject: bizgres - bizgres:

Privacy Policy | About PostgreSQL
Copyright © 1996-2018 The PostgreSQL Global Development Group