Skip site navigation (1) Skip section navigation (2)

Re: [SQL] What is the recommended machine configuration?

From: pierre(at)desertmoon(dot)com
To: reina(at)nsi(dot)edu (G(dot) Anthony Reina)
Cc: pgsql-sql(at)postgreSQL(dot)org
Subject: Re: [SQL] What is the recommended machine configuration?
Date: 1998-08-05 20:52:40
Message-ID: 19980805205240.25463.qmail@desertmoon.com (view raw or flat)
Thread:
Lists: pgsql-sql
> 
> 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

In response to

pgsql-sql by date

Next:From: The Hermit HackerDate: 1998-08-05 21:35:13
Subject: Re: [SQL] What is the recommended machine configuration?
Previous:From: Thomas GoodDate: 1998-08-05 20:15:04
Subject: mere millimetres away

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group