Re: system cache and buffer cache

Praveen Kumar N wrote:
> Buffer cache is implemented using bufferpool right(I mean in the main 
> memory).

Yes. It's in shared memory, size is controlled by the shared_buffers 
configuration parameter.

> how about system cache? Can we control the size of system cache?

It's in backend-private memory. I don't remember how it's sized.

-- 
Heikki Linnakangas
EnterpriseDB http://www.enterprisedb.com