On Tue, 2006-09-19 at 14:59 +0100, Heikki Linnakangas wrote:
> Praveen Kumar N wrote:
> > 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.
It's fixed size: syscache caches a predefined set of catalog info.
--
Praveen Kumar N wrote:
> Hi,
> can anybody explain me what is the difference between system cache
> and buffer cache?
>
> I found that keywords in PostgreSql FAQ
> http://www.postgresql.org/docs/faqs.FAQ_DEV.html#item2.1
Another important cache is the "relation cache", relcache for short,
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 memo
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
Praveen Kumar N wrote:
Hi,
can anybody explain me what is the difference between system cache
and buffer cache?
I found that keywords in PostgreSql FAQ
http://www.postgresql.org/docs/faqs.FAQ_DEV.html#item2.1
System cache is a per-row cache of system catalog tables. It's used to
speed
Hi,
can anybody explain me what is the difference between system cache
and buffer cache?
I found that keywords in PostgreSql FAQ
http://www.postgresql.org/docs/faqs.FAQ_DEV.html#item2.1
thanks in advance.
Regards,
--
N Praveen Kumar
Imagination is more important than knowledge...
