Re: [PERFORM] Memory question on win32 systems

From: Sam Mason <sam(at)samason(dot)me(dot)uk>
To: pgsql-hackers(at)postgresql(dot)org
Subject: Re: [PERFORM] Memory question on win32 systems
Date: 2008-05-29 13:45:32
Message-ID: 20080529134532.GC1723@frubble.xen.chris-lamb.co.uk
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On Thu, May 29, 2008 at 01:05:22AM +0200, Sabbiolina wrote:
> I have 4 Gigs of RAM, how do I force Postgres to use a higher part of such
> memory in order to cache more indexes, queries and so on?

PG relies on the operating system to cache most disk accesses. Looking
at the amount of memory a process directly uses isn't a good measure of
this, a better method would be to watch what the IO subsystem is doing.
If you've got lots of reads happening then the disk isn't being cached.

Sam

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Tom Lane 2008-05-29 14:12:55 Core team statement on replication in PostgreSQL
Previous Message Jorgen Austvik - Sun Norway 2008-05-29 12:22:31 Re: pg_regress: referencing shared objects from tests