aboutsummaryrefslogtreecommitdiff
path: root/src/backend/utils/cache/lsyscache.c
diff options
context:
space:
mode:
authorTom Lane <tgl@sss.pgh.pa.us>2006-06-15 02:08:09 +0000
committerTom Lane <tgl@sss.pgh.pa.us>2006-06-15 02:08:09 +0000
commit8b9bc234ad43dfa788bde40ebf12e94f16556b7f (patch)
treed883d471f95e962d7432f3b14d45d06f9a2666e5 /src/backend/utils/cache/lsyscache.c
parente1e133f2642fa444ad26749edbd9e89e9afbb169 (diff)
downloadpostgresql-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