Re: postgresql caching

From: Dmitry Tkach <dmitry(at)openratings(dot)com>
To: Kris <kkiger(at)depauw(dot)edu>
Subject: Re: postgresql caching
Date: 2003-02-28 22:28:25
Message-ID: 3E5FE289.2040202@openratings.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Dmitry Tkach 2003-02-28 22:30:02 Re: Recreating a primary key
Previous Message Dmitry Tkach 2003-02-28 22:25:58 Re: Locking rows