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

I remember reading some part of the docs I that mentioned a significant
difference in speed of queries between 64 bit and 32 bit architectures. If
you are planning on using Red Hat Linux you could just as easily swap the
PII for an Alpha and get better performance, higher IO throughput and an
all around better machine.

FYI - RedHat ships with the following 4 postgres related packages on the
alpha:
  postgresql-6.3.2-4.alpha.rpm
  postgresql-clients-6.3.2-4.alpha.rpm
  postgresql-data-6.3.2-4.alpha.rpm
  postgresql-devel-6.3.2-4.alpha.rpm

Anyone with experience using RedHat on Alpha with Postgres care to
comment?

Chris

On Wed, 5 Aug 1998, G. Anthony Reina wrote:

> 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
>
>