Date: Sun, 18 Mar 2007 13:16:26 +0100 From: Axel Rau <Axel.Rau@chaos1.de> To: freebsd-database@freebsd.org, FreeBSD AMD list <freebsd-amd64@freebsd.org> Subject: Re: New Opteron box, dedicated to PostgreSQL Message-ID: <9012051A-E60C-4408-B772-B2A733CE23F8@chaos1.de> In-Reply-To: <b41c75520703160417w672a6b92x38cac65001bc3ea1@mail.gmail.com> References: <8CDBEAF9-0945-4CD2-89C4-58AA63850ECC@Chaos1.DE> <b41c75520703160417w672a6b92x38cac65001bc3ea1@mail.gmail.com>
index | next in thread | previous in thread | raw e-mail
Am 16.03.2007 um 12:17 schrieb Claus Guttesen: > > /boot/loader.conf: > > kern.ipc.semmni=256 > kern.ipc.semmns=2048 > > > /etc/sysctl.conf: > > kern.ipc.somaxconn=2048 This one is new to me. > > # 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. Thank you for this valuable info. I will use it as a starting point. Regards, Axel --------------------------------------------------------------------- Axel Rau, ☀Frankfurt , Germany +49 69 9514 18 0help
Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?9012051A-E60C-4408-B772-B2A733CE23F8>