pg.ddx.io  pgsql-performance@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Iain <iain@mst.co.jp>
To: postuser@spr.og.th
To: Ragnar Hafstaư <gnari@simnet.is>
Cc: pgsql-performance@postgresql.org
Subject: Re: Howto Increased performace ?
Date: Tue, 28 Dec 2004 13:56:42 +0900
Message-ID: <007e01c4ec99$a2a043a0$7201a8c0@mst1x5r347kymb> (raw)
References: <2452.192.168.2.6.1103621509.squirrel@192.168.2.6>
	<00cb01c4ebb3$94aebf10$7201a8c0@mst1x5r347kymb>
	<45410.192.168.2.17.1104139293.squirrel@192.168.2.17>
	<003a01c4ebf7$503de6a0$7201a8c0@mst1x5r347kymb>
	<50978.192.168.2.17.1104161471.squirrel@192.168.2.17>
	<1104170919.23792.16.camel@localhost.localdomain>
	<58712.192.168.2.17.1104203972.squirrel@192.168.2.17>

Hi,

These are the /etc/sysctl.conf settings that I am planning to use. 
Coincidentally, these are the settings recommended by Oracle. If anything 
they would be generous, I think.

file-max 65536 (for 2.2 and 2.4 kernels)
kernel.shmall 134217728 (=128MB)
kernel.shmmax 268435456
fs.file-max 65536

By the way, when you tested your changes, was that with a busy system? I 
think that a configuration that gives the best performance (at the client 
end) on a machine with just a few connections might not be the configuration 
that will give you the best throughput when the system is stressed.

I'm certainly no expert on tuning Linux systems, or even Postgres but I'd 
suggest that you become knowlegable in the use of the various system 
monitoring tools that Linux has and keep a record of their output so you can 
compare as you change your configuration. In the end though,  I think your 
aim is to reduce swapping by tuning your memory usage for busy times.

Also, I heard that (most?what versions?) 32 bit linux kernals are slow at 
handling more than 2GB memory so a kernal upgrade might be worth 
considering.

regards
Iain 




view thread (9+ messages)

Message-ID: <007e01c4ec99$a2a043a0$7201a8c0@mst1x5r347kymb>
Permalink:  ../007e01c4ec99$a2a043a0$7201a8c0@mst1x5r347kymb/
Also on:    postgresql.org/message-id/007e01c4ec99$a2a043a0$7201a8c0@mst1x5r347kymb

 · 

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 from your mail client; the link fills in
  the headers below: reply via email
  Some clients, webmail especially, drop In-Reply-To and References from
  a link, and the reply then starts a new thread: use the mbox below.

  To: pgsql-performance@postgresql.org
  Cc: iain@mst.co.jp, postuser@spr.og.th, gnari@simnet.is
  Subject: Re: Howto Increased performace ?
  In-Reply-To: <007e01c4ec99$a2a043a0$7201a8c0@mst1x5r347kymb>
  References: <2452.192.168.2.6.1103621509.squirrel@192.168.2.6> <00cb01c4ebb3$94aebf10$7201a8c0@mst1x5r347kymb> <45410.192.168.2.17.1104139293.squirrel@192.168.2.17> <003a01c4ebf7$503de6a0$7201a8c0@mst1x5r347kymb> <50978.192.168.2.17.1104161471.squirrel@192.168.2.17> <1104170919.23792.16.camel@localhost.localdomain> <58712.192.168.2.17.1104203972.squirrel@192.168.2.17> <007e01c4ec99$a2a043a0$7201a8c0@mst1x5r347kymb>

* 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