Buffer cache is implemented using bufferpool right(I mean in the main memory).how about system cache? Can we control the size of system cache?


On Tue, 19 Sep 2006, Heikki Linnakangas wrote:

System cache is a per-row cache of system catalog tables. It's used to speed up lookup of things like function names. It's implemented in src/backend/utils/cache/syscache.c

Buffer cache is the cache managed by the buffer manager, that caches any blocks from any relation used in the system. All access to relations go through the buffer cache, using ReadBuffer/ReleaseBuffer (etc.) calls. It's implemented in src/backend/storage/buffer/bufmgr.c



--
 N Praveen Kumar
 Btech-IV CSE
 IIIT,Hyd
 AP,India

        Imagination is more important than knowledge...
                                --Albert Einstein


---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
      choose an index scan if your joining column's datatypes do not
      match

Reply via email to