Received: from nsi.edu (amethea.nsi.edu [198.133.185.9]) by hub.org (8.8.8/8.7.5) with ESMTP id QAA03165 for ; Wed, 5 Aug 1998 16:00:17 -0400 (EDT) Received: from nsi.edu (IDENT:reina@bigred.motorlab.nsi.edu [204.128.156.214]) by nsi.edu (8.9.1/8.9.1) with ESMTP id NAA11367; Wed, 5 Aug 1998 13:00:13 -0700 (PDT) Sender: reina@nsi.edu Message-ID: <35C8BA15.7775BA15@nsi.edu> Date: Wed, 05 Aug 1998 13:01:25 -0700 From: "G. Anthony Reina" Organization: The Neurosciences Institute X-Mailer: Mozilla 4.05 [en] (X11; I; Linux 2.0.34 i686) MIME-Version: 1.0 To: reina@nsi.edu, "pgsql-questions@postgresql.org" Subject: What is the recommended machine configuration? 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.? Thanks. -Tony Reina