X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 7F5848B9B16 for ; Sat, 12 Feb 2005 17:54:57 +0000 (GMT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 91177-10 for ; Sat, 12 Feb 2005 17:54:47 +0000 (GMT) Received: from fs3.ft.fo (mail-gw.ft.fo [212.55.40.2]) by svr1.postgresql.org (Postfix) with ESMTP id DB65E8B9CFF for ; Sat, 12 Feb 2005 17:54:45 +0000 (GMT) Received: from FT_DOM-MTA by fs3.ft.fo with Novell_GroupWise; Sat, 12 Feb 2005 17:54:43 +0000 Message-Id: X-Mailer: Novell GroupWise Internet Agent 6.5.1 Date: Sat, 12 Feb 2005 17:54:28 +0000 From: "John Jensen" To: , Subject: Re: Setting up data on two drives newb version. left Mime-Version: 1.0 Content-Type: text/plain; charset=US-ASCII Content-Transfer-Encoding: 7bit Content-Disposition: inline X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.05 tagged_above=0 required=5 tests=FORGED_RCVD_HELO X-Spam-Level: X-Archive-Number: 200502/105 X-Sequence-Number: 16273 Bruce Momjian has an other interesting manual on hardware performance tuning: http://candle.pha.pa.us/main/writings/pgsql/hw_performance/index.html It covers a lot of the same ground plus some other goodies. /John >>> "Joel Fradkin" 12-02-2005 16:22:28 >>> This was also in the Desknow web page. changing these parameters will probably cause postgres to not start. su - postgres pg_ctl -D /var/lib/pgsql/data start ( I actualy left the path off ) in the message it says you need to increase SHMMAX to a certain number. To do this you must be root echo /proc/sys/kernel/shmmax to make it permanent edit /etc/sysctl.conf kernel.shmmax = example shared_buffers = 20000 it is 167763968 (160mb). Joel Fradkin ---------------------------(end of broadcast)--------------------------- TIP 4: Don't 'kill -9' the postmaster