Re: postgresql caching - Mailing list pgsql-general

From Dmitry Tkach
Subject Re: postgresql caching
Date
Msg-id 3E5FE289.2040202@openratings.com
Whole thread Raw
List pgsql-general
Kris wrote:
> Does anyone know how postgresql handles caching?  Say, for example, I have a
> large database.  One that is larger than the available chunk of shared
> memory I have set aside.  Will postgresql try and cache frequently queried
> tables to memory,

Yes.
  will it try to cache frequently used query results to
> memory only, or both?

No.

Dima


pgsql-general by date:

Previous
From: "Nigel J. Andrews"
Date:
Subject: Re: Locking rows
Next
From: Dmitry Tkach
Date:
Subject: Re: Recreating a primary key