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>
next in thread | previous in thread | raw e-mail | index | archive | help
Am 16.03.2007 um 12:17 schrieb Claus Guttesen: > > /boot/loader.conf: > > kern.ipc.semmni=3D256 > kern.ipc.semmns=3D2048 > > > /etc/sysctl.conf: > > kern.ipc.somaxconn=3D2048 This one is new to me. > > # Suggestions by Vivek Khera from postgresql performance > kern.ipc.shm_use_phys=3D1 > kern.ipc.shmmax=3D1073741824 > kern.ipc.shmall=3D262144 > kern.ipc.semmsl=3D512 > kern.ipc.semmap=3D256 > > > 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, =E2=98=80Frankfurt , Germany +49 69 9514 = 18 0
Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?9012051A-E60C-4408-B772-B2A733CE23F8>