Date: Fri, 16 Mar 2007 12:17:16 +0100 From: "Claus Guttesen" <kometen@gmail.com> To: "Axel Rau" <Axel.Rau@chaos1.de> Cc: freebsd-database@freebsd.org, freebsd-amd64@freebsd.org Subject: Re: New Opteron box, dedicated to PostgreSQL Message-ID: <b41c75520703160417w672a6b92x38cac65001bc3ea1@mail.gmail.com> In-Reply-To: <8CDBEAF9-0945-4CD2-89C4-58AA63850ECC@Chaos1.DE> References: <8CDBEAF9-0945-4CD2-89C4-58AA63850ECC@Chaos1.DE>
next in thread | previous in thread | raw e-mail | index | archive | help
> while configuring my 1st PostgreSQL box with dual Opterons (2212) on > FreeBSD, I have some questions: > > 3. What are the recommendations for tuning I/O)? > - setting sysctl vfs.read_max to 16 or 32 > - rebuilding the relevant filesystem with 32K blocks and 4K frags > Are these reliable? The following were suggetions from Vivek Khera: /boot/loader.conf: kern.ipc.semmni=256 kern.ipc.semmns=2048 /etc/sysctl.conf: kern.ipc.somaxconn=2048 kern.maxfiles=65536 # Suggestions by Vivek Khera from postgresql performance kern.ipc.shm_use_phys=1 kern.ipc.shmmax=1073741824 kern.ipc.shmall=262144 kern.ipc.semmsl=512 kern.ipc.semmap=256 This is on a four-way woodcrest at 3 GHz and 16 GB ram so you may want to adjust the values. regards Claus
Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?b41c75520703160417w672a6b92x38cac65001bc3ea1>