Received: from ctron-dnm.ctron.com (ctron-dnm.enterasys.com [12.25.1.120]) by postgresql.org (Postfix) with ESMTP id 6EC5B475452 for ; Fri, 29 Mar 2002 11:08:57 -0500 (EST) Received: (from uucp@localhost) by ctron-dnm.ctron.com (8.8.7/8.8.7) id LAA03261 for ; Fri, 29 Mar 2002 11:18:57 -0500 (EST) Received: from cnc-exc2(134.141.77.103) by ctron-dnm.ctron.com via smap (4.1) id xma003237; Fri, 29 Mar 02 11:18:46 -0500 Received: by smtp.enterasys.com with Internet Mail Service (5.5.2653.19) id ; Fri, 29 Mar 2002 11:07:33 -0500 Message-ID: <59358A738F45D51186A30008C74CE250E81536@slc-exc1.ctron.com> From: "Hunter, Ray" To: Postgres SQL Mailing List Subject: Optimization Advice Date: Fri, 29 Mar 2002 11:08:05 -0500 MIME-Version: 1.0 X-Mailer: Internet Mail Service (5.5.2653.19) Content-Type: multipart/alternative; boundary="----_=_NextPart_001_01C1D73B.E9359610" X-Archive-Number: 200203/386 X-Sequence-Number: 7260 This message is in MIME format. Since your mail reader does not understand this format, some or all of this message may not be legible. ------_=_NextPart_001_01C1D73B.E9359610 Content-Type: text/plain I am currently setting up two pcs to run with apache, php, and postgres. I am looking over the Optimization that I can do with postgres and would like some sound advice. I also have some questions concerning optimization Systems: Redhat linux 7.2 with new kernel additions 1.5 gig cpu 1 gig memory 80 gig hd I was thinking of specifying about 512 for the kernel shmmax and shmall. Is this a good idea? What are some optimizations that you would suggest. Thank you, Ray Hunter Firmware Engineer ENTERASYS NETWORKS Internal: 53888 External: 801 887-9888 Email: rhunter@enterasys.com www: www.enterasys.com ------_=_NextPart_001_01C1D73B.E9359610 Content-Type: text/html Content-Transfer-Encoding: quoted-printable Optimization Advice

I am currently setting up two pcs to run with apache, php= , and postgres.  I am looking over the Optimization that I can do with= postgres and would like some sound advice.  I also have some question= s concerning optimization

Systems:
Redhat linux 7.2 with new kernel additions
1.5 gig cpu
1 gig memory
80 gig hd


I was thinking of specifying about 512 for the kernel shm= max and shmall.  Is this a good idea?  What are some optimization= s that you would suggest.



Thank you,

Ray Hunter
Firmware Engineer

ENTERASYS NETWORKS

Internal:       53888
External:       801 887-98= 88
Email:          = rhunter@enterasys.com
www:         &nb= sp;  www.enterasys.com


------_=_NextPart_001_01C1D73B.E9359610--