cached memory - Mailing list pgsql-admin

From dx k9
Subject cached memory
Date
Msg-id BAY116-W299DD053ED5A22FA305F15D1810@phx.gbl
Whole thread Raw
Responses Re: cached memory  ("Scott Marlowe" <scott.marlowe@gmail.com>)
List pgsql-admin
    Hi,

   In looking at some cacti memory usage graphs, the Oracle servers show only 6 of a total of16 GB of RAM as 'Total Available'.  Whereas,  our Postgres version 8.24 servers show all 16 GB of RAM totally available or free.    Some people are asking why Postgres doesn't take that memory and lock into it, so you can't see less 'total available' memory.   We use a lot of B-tree indexes.   This may or may not be related, but it there a good way to make sure those stay in memory? 
  
  Thanks,
  ~DjK.hmmessage P{margin:0px;padding:0px}body.hmmessage{FONT-SIZE: 10pt;FONT-FAMILY:Tahoma}


Boo! Scare away worms, viruses and so much more! Try Windows Live OneCare! Try now!

pgsql-admin by date:

Previous
From: Tom Lane
Date:
Subject: Re: Error when trying to recover from filesystem backup
Next
From: "Scott Marlowe"
Date:
Subject: Re: postgres bogged down beyond tolerance