diff options
author | Tom Lane <tgl@sss.pgh.pa.us> | 2006-06-15 02:08:09 +0000 |
---|---|---|
committer | Tom Lane <tgl@sss.pgh.pa.us> | 2006-06-15 02:08:09 +0000 |
commit | 8b9bc234ad43dfa788bde40ebf12e94f16556b7f (patch) | |
tree | d883d471f95e962d7432f3b14d45d06f9a2666e5 /src/backend/utils/cache/lsyscache.c | |
parent | e1e133f2642fa444ad26749edbd9e89e9afbb169 (diff) | |
download | postgresql-8b9bc234ad43dfa788bde40ebf12e94f16556b7f.tar.gz postgresql-8b9bc234ad43dfa788bde40ebf12e94f16556b7f.zip |
Remove the limit on the number of entries allowed in catcaches, and
remove the infrastructure needed to enforce the limit, ie, the global
LRU list of cache entries. On small-to-middling databases this wins
because maintaining the LRU list is a waste of time. On large databases
this wins because it's better to keep more cache entries (we assume
such users can afford to use some more per-backend memory than was
contemplated in the Berkeley-era catcache design). This provides a
noticeable improvement in the speed of psql \d on a 10000-table
database, though it doesn't make it instantaneous.
While at it, use per-catcache settings for the number of hash buckets
per catcache, rather than the former one-size-fits-all value. It's a
bit silly to be using the same number of hash buckets for, eg, pg_am
and pg_attribute. The specific values I used might need some tuning,
but they seem to be in the right ballpark based on CATCACHE_STATS
results from the standard regression tests.
Diffstat (limited to 'src/backend/utils/cache/lsyscache.c')
0 files changed, 0 insertions, 0 deletions