On Sun, 31 Aug 2003, Jefim M wrote: > > I have the following setup for my PostgreSQL box: > 4GB Ram > Dual CPU > Redhat 7.3 with 2.4.20-18.7smp kernel > 2 network cards - one is dedicated to internal traffic to the NetApp filer > and other is used for other traffic > > and all the Postgres database resides on the NetApp filer using NFS. > Number of the connection to the database is configured to 64. > > What are best configuration setting I need to use on my PostgreSQL and Linux > boxes to get the best performance from PostgresSQL? > Are there any recomendations for the given setup (having the data on the > remote server) ?
We use a netapp and I had to muck around with the default settings under rh7.2 to get reliable behaviour. Note that our database does not sit on a netapp, only our semi-static web content does. Here's the settings I added, at the behest of one of our unix / linux ubergeeks: timeo=10,retry=1,bg,soft,intr,rsize=8192,wsize=8192 ---------------------------(end of broadcast)--------------------------- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
