Managing caches for multi-cluster HP-UX box - Mailing list pgsql-general

From Ed L.
Subject Managing caches for multi-cluster HP-UX box
Date
Msg-id 200408181437.07610.pgsql@bluepolka.net
Whole thread Raw
List pgsql-general
We have ia64 box running HP-UX B.11.23, 16GB of RAM, and we'll eventually
have 10-20 high volume clusters installed.  We could definitely use all the
RAM caching DB data.  On our Linux boxes, we set the cluster shared_buffer
settings quite low (10000) and defer caching to the OS, and the OS seems to
play quite nicely with us, giving up buffer memory whenever an application
needs it.  On HP-UX, I'm hearing a different story:  the OS does not
perform well with OS cache size > 500MB due to contention between vhand and
the buffer cache.  That suggests to me that we would need to manage the
allocation of the bulk of shared memory across these 10-20 clusters to
utilize the available RAM, a DBA headache we'd like to avoid if possible.
Am I missing something?  Any suggestions on making this HP-UX box work
better for our situation, short of adding RAM?



pgsql-general by date:

Previous
From: Steve Crawford
Date:
Subject: Re: FATAL: invalid frontend message type 8
Next
From: Jean-Luc Lachance
Date:
Subject: Re: psql - user defined SQL variables