Optimization Advice - Mailing list pgsql-sql

From Hunter, Ray
Subject Optimization Advice
Date
Msg-id 59358A738F45D51186A30008C74CE250E81536@slc-exc1.ctron.com
Whole thread Raw
List pgsql-sql
<p><font size="2">I am currently setting up two pcs to run with apache, php, and postgres.  I am looking over the
Optimizationthat I can do with postgres and would like some sound advice.  I also have some questions concerning
optimization</font><p><fontsize="2">Systems:</font><br /><font size="2">Redhat linux 7.2 with new kernel
additions</font><br/><font size="2">1.5 gig cpu</font><br /><font size="2">1 gig memory</font><br /><font size="2">80
gighd</font><br /><p><font size="2">I was thinking of specifying about 512 for the kernel shmmax and shmall.  Is this a
goodidea?  What are some optimizations that you would suggest.</font><br /><br /><p><font size="2">Thank
you,</font><p><fontsize="2">Ray Hunter</font><br /><font size="2">Firmware Engineer</font><p><font size="2">ENTERASYS
NETWORKS</font><p><fontsize="2">Internal:       53888</font><br /><font size="2">External:       801 887-9888</font><br
/><fontsize="2">Email:          rhunter@enterasys.com</font><br /><font size="2">www:           
www.enterasys.com</font><br/> 

pgsql-sql by date:

Previous
From: Stephan Szabo
Date:
Subject: Re: Table constraints
Next
From: Jie Liang
Date:
Subject: dead session terminate