pg.ddx.io  pgsql-performance@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Christopher Browne <cbbrowne@acm.org>
To: pgsql-performance@postgresql.org
Subject: Re: tuning for AIX 5L with large memory
Date: Fri, 21 May 2004 21:28:08 -0400
Message-ID: <m3vfip8d3r.fsf@wolfe.cbbrowne.com> (raw)
References: <40AE8F78.2070901@drivefaster.net>

Clinging to sanity, fbsd@drivefaster.net (Dan Harris) mumbled into her beard:
> I will soon have at my disposal a new IBM pSeries server.  The main
> mission for this box will be to serve several pg databases.  I have
> ordered 8GB of RAM and want to learn the best way to tune pg and AIX
> for this configuration.  Specifically, I am curious about shared
> memory limitations.  I've had to tune the shmmax on linux machines
> before but I'm new to AIX and not sure if this is even required on
> that platform?  Google has not been much help for specifics here.
>
> Hoping someone else here has a similar platform and can offer some advice..

We have a couple of these at work; they're nice and fast, although the
process of compiling things, well, "makes me feel a little unclean."

One of our sysadmins did all the "configuring OS stuff" part; I don't
recall offhand if there was a need to twiddle something in order to
get it to have great gobs of shared memory.

A quick Google on this gives me the impression that AIX supports, out
of the box, multiple GB of shared memory without special kernel
configuration.  A DB/2 configuration guide tells users of Solaris and
HP/UX that they need to set shmmax in sundry config files and reboot.
No such instruction for AIX.

If it needs configuring, it's probably somewhere in SMIT.  And you can
always try starting up an instance to see how big it'll let you make
shared memory.

The usual rule of thumb has been that having substantially more than
10000 blocks worth of shared memory is unworthwhile.  I don't think
anyone has done a detailed study on AIX to see if bigger numbers play
well or not.  I would think that having more than about 1 to 1.5GB of
shared memory in use for buffer cache would start playing badly, but I
have no numbers.
-- 
select 'cbbrowne' || '@' || 'cbbrowne.com';
http://www3.sympatico.ca/cbbrowne/sap.html
Would-be National Mottos:
USA: "We don't care where you come from.  We can't find our *own*
country on a map..."



view thread (6+ messages)  latest in thread

Message-ID: <m3vfip8d3r.fsf@wolfe.cbbrowne.com>
Permalink:  ../m3vfip8d3r.fsf@wolfe.cbbrowne.com/
Also on:    postgresql.org/message-id/m3vfip8d3r.fsf@wolfe.cbbrowne.com

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-performance@postgresql.org
  Cc: cbbrowne@acm.org
  Subject: Re: tuning for AIX 5L with large memory
  In-Reply-To: <m3vfip8d3r.fsf@wolfe.cbbrowne.com>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox