X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [64.117.224.130]) by svr1.postgresql.org (Postfix) with ESMTP id 08E79D1C90E for ; Wed, 30 Jul 2003 18:59:42 +0000 (GMT) Received: from svr1.postgresql.org ([64.117.224.193]) by localhost (neptune.hub.org [64.117.224.130]) (amavisd-new, port 10024) with ESMTP id 78640-10 for ; Wed, 30 Jul 2003 15:58:40 -0300 (ADT) Received: from silmaril.syscor.priv (h24-77-52-251.sbm.shawcable.net [24.77.52.251]) by svr1.postgresql.org (Postfix) with ESMTP id 6962CD1C4EB for ; Wed, 30 Jul 2003 15:59:39 -0300 (ADT) Received: from syscor.com (strider.syscor.priv [192.168.1.3]) by silmaril.syscor.priv (8.12.8/8.12.8) with ESMTP id h6UIxhUe024572 for ; Wed, 30 Jul 2003 11:59:43 -0700 Message-ID: <3F28159E.6090606@syscor.com> Date: Wed, 30 Jul 2003 11:59:42 -0700 From: Ron User-Agent: Mozilla/5.0 (Windows; U; Windows NT 5.0; en-US; rv:1.3) Gecko/20030312 X-Accept-Language: en-us, en MIME-Version: 1.0 To: pgsql-performance@postgresql.org Subject: Re: postgresql.conf References: <20030730113413.6872.h018.c000.wm@mail.treat.com.criticalpath.net> <200307301143.11609.josh@agliodbs.com> In-Reply-To: <200307301143.11609.josh@agliodbs.com> Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200307/486 X-Sequence-Number: 2779 Josh Berkus wrote: >Robert, > > > >>Are you planning on differentiating between dedicated machines and >> >> >multi-server > > >>machines? For example, a dedicated database for a webserver would be tuned >>differently from a server that was running both the webserver and the >> >> >database on > > >>the same machine. >> >> > >My thought is when we define "Small Machine" in at the top of the file we >define it as "Small Machine or Multi-Purpose machine". The settings should >be nearly the same for a machine that has only 64MB of *available* RAM as one >that has only 96MB of RAM at all. > > > We are using postgres 7.3.2 for one of our clients with a smallish db, on a p4 with 4G ram box which also servers as a web server and a web-based file repository (~ 80G). We are starting another project for another customer, on a p4 with 2G ram, and the db will be larger, approx 7-15G when finished. This box will also be used as a web server, and as it won't go 'live' until the fall, will run 7.4. I don't know if this is representative of other postgresql installs, but I would also put in my vote for the differentiation added, as these are not small machines but are multi-server boxes. my 2 cents worth Ron PS the new postgresql.conf performance tuning docs are extremely helpful, thanks