X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id D08D452851 for ; Mon, 6 Jun 2005 18:00:04 -0300 (ADT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 00251-05 for ; Mon, 6 Jun 2005 20:59:52 +0000 (GMT) Received: from wproxy.gmail.com (wproxy.gmail.com [64.233.184.207]) by svr1.postgresql.org (Postfix) with ESMTP id 695785287E for ; Mon, 6 Jun 2005 17:59:51 -0300 (ADT) Received: by wproxy.gmail.com with SMTP id 68so2260413wra for ; Mon, 06 Jun 2005 13:59:53 -0700 (PDT) DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=beta; d=gmail.com; h=received:message-id:date:from:reply-to:to:subject:cc:in-reply-to:mime-version:content-type:content-transfer-encoding:content-disposition:references; b=Y3cfX4bbjJaHRqBk1B1lAGLBJygWEsq+y6Tpjm2nxmELWfgwuT4RA5wzX6aK9/xdkv8CuLFW9Xw5levaOfnrN8YO4KgfhUkGrOB4Py2OuKcm8Xy0J3bGy4dnPkqDfSybgBGyq75FwuVMj7138rudiTbtXmgaX/dwV5KOBFl2HxE= Received: by 10.54.6.56 with SMTP id 56mr2251317wrf; Mon, 06 Jun 2005 13:59:21 -0700 (PDT) Received: by 10.54.150.16 with HTTP; Mon, 6 Jun 2005 13:59:21 -0700 (PDT) Message-ID: Date: Mon, 6 Jun 2005 16:59:21 -0400 From: Mike Rylander Reply-To: Mike Rylander To: Mark Rinaudo Subject: Re: Postgresql on an AMD64 machine Cc: pgsql-performance@postgresql.org In-Reply-To: <1118080420.1644.23.camel@penguin1> Mime-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable Content-Disposition: inline References: <1118080420.1644.23.camel@penguin1> X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.069 tagged_above=0 required=5 tests=AWL, RCVD_BY_IP X-Spam-Level: X-Archive-Number: 200506/135 X-Sequence-Number: 12772 On 06 Jun 2005 12:53:40 -0500, Mark Rinaudo wrote: > I'm not sure if this is the appropriate list to post this question to > but i'm starting with this one because it is related to the performance > of Postgresql server. I have a Penguin Computing dual AMD 64 bit > opteron machine with 8 Gigs of memory. In my attempt to increase the > number of shared_buffers from the default to 65000 i was running into a > semget error when trying to start Postgresql. After reading the > documentation I adjusted the semaphore settings in the kernel to allow > Postgresql to start successfully. With this configuration running if I > do a ipcs -u i get the following. On my HP-585, 4xOpteron, 16G RAM, Gentoo Linux (2.6.9): $ ipcs -u i ------ Shared Memory Status -------- segments allocated 1 pages allocated 34866 pages resident 31642 pages swapped 128 Swap performance: 0 attempts 0 successes ------ Semaphore Status -------- used arrays =3D 7 allocated semaphores =3D 119 ------ Messages: Status -------- allocated queues =3D 0 used headers =3D 0 used space =3D 0 bytes Did you perhaps disable spinlocks when compiling PG? --=20 Mike Rylander mrylander@gmail.com GPLS -- PINES Development Database Developer http://open-ils.org