Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-general by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group