From owner-freebsd-questions@FreeBSD.ORG Wed Aug 27 19:11:00 2008 Return-Path: Delivered-To: freebsd-questions@freebsd.org Received: from mx1.freebsd.org (mx1.freebsd.org [IPv6:2001:4f8:fff6::34]) by hub.freebsd.org (Postfix) with ESMTP id 4A50E106567A for ; Wed, 27 Aug 2008 19:11:00 +0000 (UTC) (envelope-from jas@pcjas.obspm.fr) Received: from blade2-ext.obspm.fr (blade2-ext.obspm.fr [145.238.186.8]) by mx1.freebsd.org (Postfix) with ESMTP id DAAE08FC16 for ; Wed, 27 Aug 2008 19:10:59 +0000 (UTC) (envelope-from jas@pcjas.obspm.fr) Received: from pcjas.obspm.fr (pcjas.obspm.fr [145.238.184.233]) by blade2-ext.obspm.fr (8.13.8/8.13.8/SIO Observatoire de Paris - 15/11/07) with ESMTP id m7RJAwmq024975 (version=TLSv1/SSLv3 cipher=DHE-RSA-AES256-SHA bits=256 verify=NOT) for ; Wed, 27 Aug 2008 21:10:58 +0200 Received: from pcjas.obspm.fr (localhost [127.0.0.1]) by pcjas.obspm.fr (8.14.2/8.14.2) with ESMTP id m7RJAwmM046480 for ; Wed, 27 Aug 2008 21:10:58 +0200 (CEST) (envelope-from jas@pcjas.obspm.fr) Received: (from jas@localhost) by pcjas.obspm.fr (8.14.2/8.14.2/Submit) id m7RJAvPL046479 for freebsd-questions@freebsd.org; Wed, 27 Aug 2008 21:10:57 +0200 (CEST) (envelope-from jas) Date: Wed, 27 Aug 2008 21:10:57 +0200 From: Albert Shih To: freebsd-questions@freebsd.org Message-ID: <20080827191057.GA46302@pcjas.obspm.fr> MIME-Version: 1.0 Content-Type: text/plain; charset=iso-8859-1 Content-Disposition: inline Content-Transfer-Encoding: 8bit User-Agent: Mutt/1.5.18 (2008-05-17) X-Greylist: Sender IP whitelisted, not delayed by milter-greylist-4.0 (blade2-ext.obspm.fr [145.238.186.20]); Wed, 27 Aug 2008 21:10:58 +0200 (CEST) X-Virus-Scanned: ClamAV 0.93.3/8100/Wed Aug 27 19:58:36 2008 on blade2-ext.obspm.fr X-Virus-Status: Clean Subject: kern.ipc.sem* and postgresql X-BeenThere: freebsd-questions@freebsd.org X-Mailman-Version: 2.1.5 Precedence: list Reply-To: Albert.Shih@obspm.fr List-Id: User questions List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Wed, 27 Aug 2008 19:11:00 -0000 Hi all Classic question but I don't find the answers by google. If I've server with X procs, N Go ram and if the only purpose of this server is to run a postgresql daemon how can I known/calculate what I must give to those variable set kern.ipc.semmni=? set kern.ipc.semmns=? set kern.ipc.semmnu=? and kern.ipc.shmall=? kern.ipc.shmmax=? kern.ipc.semmap=? Once those variables is determined how can I known/calculate the variable in postgresql.conf ? shared_buffers = 32MB # min 128kB or max_connections*16kB # (change requires restart) #temp_buffers = 8MB # min 800kB #max_prepared_transactions = 5 # can be 0 or more # (change requires restart) # Note: Increasing max_prepared_transactions costs ~600 bytes of shared # memory # per transaction slot, plus lock space (see max_locks_per_transaction). #work_mem = 1MB # min 64kB #maintenance_work_mem = 16MB # min 1MB #max_stack_depth = 2MB # min 100kB # - Free Space Map - max_fsm_pages = 204800 # min max_fsm_relations*16, 6 bytes each # (change requires restart) #max_fsm_relations = 1000 # min 100, ~70 bytes each # (change requires restart) # - Kernel Resource Usage - #max_files_per_process = 1000 # min 25 ? Regards. JAS -- Albert SHIH SIO batiment 15 Observatoire de Paris Meudon 5 Place Jules Janssen 92195 Meudon Cedex Heure local/Local time: Mer 27 aoû 2008 21:06:02 CEST