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 BEEA7D1B4E3 for ; Mon, 6 Oct 2003 06:13:00 +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 92263-08 for ; Mon, 6 Oct 2003 03:12:12 -0300 (ADT) Received: from smtp.pspl.co.in (unknown [202.54.11.65]) by svr1.postgresql.org (Postfix) with ESMTP id 42A54D1B4EB for ; Mon, 6 Oct 2003 03:12:09 -0300 (ADT) Received: (from root@localhost) by smtp.pspl.co.in (8.12.9/8.12.9) id h966FnfA016113 for ; Mon, 6 Oct 2003 11:45:49 +0530 Received: from persistent.co.in (daithan.intranet.pspl.co.in [192.168.7.161]) (authenticated bits=0) by persistent.co.in (8.12.9/8.12.9) with ESMTP id h966FiYM016019; Mon, 6 Oct 2003 11:45:47 +0530 Message-ID: <3F810796.8010403@persistent.co.in> Date: Mon, 06 Oct 2003 11:41:34 +0530 From: Shridhar Daithankar Organization: Persistent Systems Pvt. Ltd. User-Agent: Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.5b) Gecko/20030917 Thunderbird/0.3a X-Accept-Language: en-us, en MIME-Version: 1.0 To: Stef Cc: Tom Lane , pgsql-performance@postgresql.org Subject: Re: Postgres low end processing. References: <20031003163040.3641f39a.svb@ucs.co.za> <24646.1065195774@sss.pgh.pa.us> <20031003181002.20cc6912.svb@ucs.co.za> <26554.1065198720@sss.pgh.pa.us> <20031003195238.16fc1229.svb@ucs.co.za> In-Reply-To: <20031003195238.16fc1229.svb@ucs.co.za> Content-Type: text/plain; charset=us-ascii; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200310/168 X-Sequence-Number: 3916 Stef wrote: > On Fri, 03 Oct 2003 12:32:00 -0400 > Tom Lane wrote: > > => What exactly is failing? And what's the platform, anyway? > > Nothing is really failing atm, except the funds for better > hardware. JBOSS and some other servers need to be > run on these machines, along with linux, which will be > a minimal RH >= 7.2 with kernel 2.4.21 > (Any better suggestions here?) > > In this case, whatever is the least amount of memory > postgres can run on, is what is needed. So this is still > a kind of feasibility study. Of course, it will still be thoroughly > tested, if it turns out to be possible. (Which I know it is, but not how) If you mean to say that postgresql should use just 8 MB of RAM rather than running it on a 8MB machine, then that is impossible given how much postgresql relies upon OS cache. You may configure postgresql with 8MB shared memory or the old holy default of 512K, but if your database is 100MB and OS is caching half of it on behalf of postgresql, your goal is already missed.. Shridhar