Re: Used Memory

From: "Kevin Grittner" <Kevin(dot)Grittner(at)wicourts(dot)gov>
To: <cpc(at)cybees(dot)com>
Cc: <pgsql-performance(at)postgresql(dot)org>
Subject: Re: Used Memory
Date: 2005-10-24 15:50:57
Message-ID: 435CBC9202000025000001AB@gwmta.wicourts.gov
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

In addition to what Mark pointed out, there is the possibility that a
query
is running which is scanning a large table or otherwise bringing in a
large number of pages from disk. That would first use up all available
unused cache space, and then may start replacing some of your
frequently used data. This can cause slowness for some time after the
process which flushed the cache, as pages are reread and recached.

Keep in mind that the cache could be flushed by some external process,
such as copying disk files.

The use of free memory for caching is not slowing you down; but if it
coincides with slowness, it could be a useful clue.

-Kevin

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Craig A. James 2005-10-24 17:00:04 Re: Used Memory
Previous Message Steinar H. Gunderson 2005-10-24 15:32:48 Re: What gets cached?