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 703F7D1B557 for ; Fri, 3 Oct 2003 18:34:55 +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 10568-08 for ; Fri, 3 Oct 2003 15:34:06 -0300 (ADT) Received: from lakemtao02.cox.net (lakemtao02.cox.net [68.1.17.243]) by svr1.postgresql.org (Postfix) with ESMTP id 1E95CD1B4EF for ; Fri, 3 Oct 2003 15:34:05 -0300 (ADT) Received: from lhosts ([68.11.66.83]) by lakemtao02.cox.net (InterMail vM.5.01.06.05 201-253-122-130-105-20030824) with ESMTP id <20031003183401.KDPD17750.lakemtao02.cox.net@lhosts> for ; Fri, 3 Oct 2003 14:34:01 -0400 Subject: Re: Postgres low end processing. From: Ron Johnson To: PgSQL Performance ML In-Reply-To: <20031003195238.16fc1229.svb@ucs.co.za> 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> Content-Type: text/plain Message-Id: <1065206040.1513.98.camel@haggis> Mime-Version: 1.0 X-Mailer: Ximian Evolution 1.4.4 Date: Fri, 03 Oct 2003 13:34:00 -0500 Content-Transfer-Encoding: 7bit X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200310/99 X-Sequence-Number: 3847 On Fri, 2003-10-03 at 12:52, 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) JBOSS, PostgreSQL & 2.4.21 all on a computer w/ 8MB RAM? A 486 or *very* low end Pentium? It'll thrash (in the literal sense) the page files. *No* work will get done. -- ----------------------------------------------------------------- Ron Johnson, Jr. ron.l.johnson@cox.net Jefferson, LA USA "...always eager to extend a friendly claw"