Received: from desertmoon.com (qmailr@desertmoon.com [198.182.124.2]) by hub.org (8.8.8/8.7.5) with SMTP id QAA12522 for ; Wed, 5 Aug 1998 16:48:39 -0400 (EDT) From: pierre@desertmoon.com Received: (qmail 25464 invoked by uid 100); 5 Aug 1998 20:52:40 -0000 Message-ID: <19980805205240.25463.qmail@desertmoon.com> Date: 5 Aug 1998 13:52:40 -0700 Subject: Re: [SQL] What is the recommended machine configuration? To: reina@nsi.edu (G. Anthony Reina) Date: Wed, 5 Aug 1998 13:52:40 -0700 (MST) Cc: pgsql-sql@postgreSQL.org In-Reply-To: <35C8BA15.7775BA15@nsi.edu> from "G. Anthony Reina" at Aug 5, 98 01:01:25 pm X-Mailer: ELM [version 2.4 PL25] MIME-Version: 1.0 Content-Type: text/plain; charset=US-ASCII Content-Transfer-Encoding: 7bit > > We are planning to dedicate a new Pentium II/400 MHz with Red Hat Linux > exclusively to our Postgres database. The database size is several > hundred megs. I have been told that the more RAM I have for the machine, > > the faster I'll be able to access the data. Does anyone have any > recommendations on the amount of RAM that would be optimal? If you had > to set up the ideal system to run a Postgres database of, let's say, 1 > Gig in size (spread across 10 tables), how would you allocate it in > terms of processor, OS, RAM, hard disk space, etc.? > I'm not much of an expert but the system I'm putting together has between 15-20 tables, comprising about 250k rows totaling about 1.5-2GB of disk space. Right now I'm running under BSDi 3.0 with 128MB RAM on a PPRO 200. Performance is great...almost no issues.... Pierre