X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [64.117.224.192]) by svr1.postgresql.org (Postfix) with ESMTP id 992EECC003 for ; Mon, 14 Jul 2003 14:27:02 +0000 (GMT) Received: from svr1.postgresql.org ([64.117.224.193]) by localhost (svr4.postgresql.org [64.117.224.192]) (amavisd-new, port 10024) with ESMTP id 17452-08 for ; Mon, 14 Jul 2003 14:27:22 +0000 (GMT) Received: from domain.com (unknown [208.254.142.2]) by svr1.postgresql.org (Postfix) with SMTP id 400B9CBC33 for ; Mon, 14 Jul 2003 11:27:00 -0300 (ADT) Received: (qmail 80882 invoked from network); 14 Jul 2003 14:27:24 -0000 Received: from unknown (HELO localhost) (127.0.0.1) by localhost.uu.net with SMTP; 14 Jul 2003 14:27:24 -0000 Received: from showie ([172.18.7.196] [172.18.7.196]) by mail1.centwire.com (VaMailArmor-2.0.1.7) id 80820-07545FFD; Mon, 14 Jul 2003 09:27:21 -0500 Message-ID: <012701c34a14$9b60ce80$c40712ac@showie> From: "Stephen Howie" To: Subject: Tunning FreeeBSD and PostgreSQL Date: Mon, 14 Jul 2003 09:31:26 -0500 MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_NextPart_000_0124_01C349EA.B2860B90" X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 6.00.2800.1158 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1165 X-AntiVirus: checked by Vexira MailArmor (version: 2.0.1.7; VAE: 6.20.0.1; VDF: 6.20.0.37; host: mail2.centwire.com) X-Virus-Scanned: by amavisd-new at postgresql.org X-Spam-Status: No, hits=1.2 tagged_above=0.0 required=5.0 tests=HTML_40_50, HTML_MESSAGE X-Spam-Level: * X-Archive-Number: 200307/220 X-Sequence-Number: 2513 This is a multi-part message in MIME format. ------=_NextPart_000_0124_01C349EA.B2860B90 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Tried to search the list but the search wasn't working. I have a server running strictly PostgreSQL that I'm trying to tune for per= formance. The specs are 2 X 2.4 Athlon MP processors 2G Reg DDR FreeBSD 4.8 SMP kernel complied PostgreSQL 7.3.3 4 X 80G IDE Raid 5 My problem is that I have not totally put my head around the concepts of th= e shmmax, shmmaxpgs, etc.... As it pertains to my current setup and the sh= ared mem values in postgresql.conf. I'm looking for a good rule of thumb w= hen approaching this. Any help or direction would be greatly appreciated. Thanks Stephen Howie ------=_NextPart_000_0124_01C349EA.B2860B90 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable
Tried to search the list but the search wa= sn't=20 working.
 
I have a server running strictly PostgreSQ= L that=20 I'm trying to tune for performance. The specs are
 
2 X 2.4 Athlon MP processors
2G Reg DDR
FreeBSD 4.8 SMP kernel complied
PostgreSQL 7.3.3
4 X 80G IDE Raid 5
 
My problem is that I have not totally put = my head=20 around the concepts of the shmmax, shmmaxpgs, etc....  As it pertains = to my=20 current setup and the shared mem values in postgresql.conf.  I'm looki= ng=20 for a good rule of thumb when approaching this.  Any help or direction= =20 would be greatly appreciated.
 
Thanks
Stephen Howie
------=_NextPart_000_0124_01C349EA.B2860B90--