pg.ddx.io  pgsql-sql@postgresql.org mailing list archive  
help / color / mirror / Atom feed
What is the recommended machine configuration?
9+ messages / 8 participants
[nested] [flat]

* What is the recommended machine configuration?
@ 1998-08-05 20:01  G. Anthony Reina <reina@nsi.edu>
  0 siblings, 3 replies; 9+ messages in thread

From: G. Anthony Reina @ 1998-08-05 20:01 UTC (permalink / raw)
  To: 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.?

Thanks.
-Tony Reina




^ permalink  raw  reply  [nested|flat] 9+ messages in thread

* Re: [SQL] What is the recommended machine configuration?
@ 1998-08-05 20:52  pierre@desertmoon.com
  parent: G. Anthony Reina <reina@nsi.edu>
  2 siblings, 0 replies; 9+ messages in thread

From: pierre@desertmoon.com @ 1998-08-05 20:52 UTC (permalink / raw)
  To: reina@nsi.edu; +Cc: 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



^ permalink  raw  reply  [nested|flat] 9+ messages in thread

* Re: [SQL] What is the recommended machine configuration?
@ 1998-08-05 21:35  The Hermit Hacker <scrappy@hub.org>
  parent: G. Anthony Reina <reina@nsi.edu>
  2 siblings, 3 replies; 9+ messages in thread

From: The Hermit Hacker @ 1998-08-05 21:35 UTC (permalink / raw)
  To: G. Anthony Reina <reina@nsi.edu>; +Cc: pgsql-sql

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

I'm going to poke my head up here, as carefully as I can.  This is *not*
meant to start a flame war, I'm just bringing up a point that someone else
made a short while ago..

There was a discussion a little while back (probably prompted by me)
concerning Linux vs FreeBSD, and their "intended uses".  One of the
comments made by a *Linux* user went to the effect that Linux makes a
great desktop computer (ie. MicroSloth Windows replacement), but if you
want a *server* operating system, go with FreeBSD, as it scales better.

This was a comment from a Linux user...there are several Linux users on
the lists, and Thomas (one of the core developers) is one of them, so it
isn't as if PostgreSQL isn't *extensively* tested under Linux...

One thing in RedHat's favor, though, is that PostgreSQL comes with the
operating system as an installable package...

Marc G. Fournier                                
Systems Administrator @ hub.org 
primary: scrappy@hub.org           secondary: scrappy@{freebsd|postgresql}.org 




^ permalink  raw  reply  [nested|flat] 9+ messages in thread

* Re: [SQL] What is the recommended machine configuration?
@ 1998-08-05 22:30  Brook Milligan <brook@trillium.NMSU.Edu>
  parent: The Hermit Hacker <scrappy@hub.org>
  2 siblings, 1 reply; 9+ messages in thread

From: Brook Milligan @ 1998-08-05 22:30 UTC (permalink / raw)
  To: scrappy@hub.org; +Cc: reina@nsi.edu; pgsql-sql

   One thing in RedHat's favor, though, is that PostgreSQL comes with the
   operating system as an installable package...

So does FreeBSD, doesn't it?  I know NetBSD does.

Cheers,
Brook



^ permalink  raw  reply  [nested|flat] 9+ messages in thread

* Re: [SQL] What is the recommended machine configuration?
@ 1998-08-05 22:45  The Hermit Hacker <scrappy@hub.org>
  parent: Brook Milligan <brook@trillium.NMSU.Edu>
  0 siblings, 0 replies; 9+ messages in thread

From: The Hermit Hacker @ 1998-08-05 22:45 UTC (permalink / raw)
  To: Brook Milligan <brook@trillium.NMSU.Edu>; +Cc: reina@nsi.edu; pgsql-sql

On Wed, 5 Aug 1998, Brook Milligan wrote:

>    One thing in RedHat's favor, though, is that PostgreSQL comes with the
>    operating system as an installable package...
> 
> So does FreeBSD, doesn't it?  I know NetBSD does.

	We have it as part of "ports", which means that as long as you
haven't done anything weird to your machine, it will compile, but compile
it you have to do.  RedHat has it as a pre-compiled package that you just
install just as you would any other package, when you install the
operating system...

Marc G. Fournier                                
Systems Administrator @ hub.org 
primary: scrappy@hub.org           secondary: scrappy@{freebsd|postgresql}.org 




^ permalink  raw  reply  [nested|flat] 9+ messages in thread

* Re: [SQL] What is the recommended machine configuration?
@ 1998-08-06 00:07  D'Arcy J.M. Cain <darcy@druid.net>
  parent: The Hermit Hacker <scrappy@hub.org>
  2 siblings, 1 reply; 9+ messages in thread

From: darcy@druid.net @ 1998-08-06 00:07 UTC (permalink / raw)
  To: scrappy@hub.org; +Cc: reina@nsi.edu; pgsql-sql

Thus spake The Hermit Hacker
> One thing in RedHat's favor, though, is that PostgreSQL comes with the
> operating system as an installable package...

With NetBSD too.  I would be surprised if it wasn't in the FreeBSD
packages as well.

-- 
D'Arcy J.M. Cain <darcy@{druid|vex}.net>   |  Democracy is three wolves
http://www.druid.net/darcy/                |  and a sheep voting on
+1 416 424 2871     (DoD#0082)    (eNTP)   |  what's for dinner.



^ permalink  raw  reply  [nested|flat] 9+ messages in thread

* Re: [SQL] What is the recommended machine configuration?
@ 1998-08-06 12:20  Tom Good <tomg@nrnet.org>
  parent: D'Arcy J.M. Cain <darcy@druid.net>
  0 siblings, 0 replies; 9+ messages in thread

From: Tom Good @ 1998-08-06 12:20 UTC (permalink / raw)
  To: pgsql-sql; +Cc: The Hermit Hacker <scrappy@hub.org>; volkerdi@mhd1.moorhead.msus.edu

On Wed, 5 Aug 1998, D'Arcy J.M. Cain wrote:

> Thus spake The Hermit Hacker
> > One thing in RedHat's favor, though, is that PostgreSQL comes with the
> > operating system as an installable package...
> 
> With NetBSD too.  I would be surprised if it wasn't in the FreeBSD
> packages as well.

And we are working on this for a future release of slackware...

 Cheers,
 Tom

    ----------- Sisters of Charity Medical Center ----------
                    Department of Psychiatry
                              ----     
 Thomas Good, System Administrator            <tomg@q8.nrnet.org>
 North Richmond CMHC/Residential Services     Phone: 718-354-5528
 75 Vanderbilt Ave, Quarters 8                Fax:   718-354-5056
 Staten Island, NY   10304                    www.panix.com/~ugd
                              ----     
 Powered by PostgreSQL 6.3.2 / Perl 5.004 / DBI-0.91::DBD-PG-0.69 




^ permalink  raw  reply  [nested|flat] 9+ messages in thread

* Re: [SQL] What is the recommended machine configuration?
@ 1998-08-06 14:38  Chris Johnson <cmj@inline-design.com>
  parent: G. Anthony Reina <reina@nsi.edu>
  2 siblings, 0 replies; 9+ messages in thread

From: Chris Johnson @ 1998-08-06 14:38 UTC (permalink / raw)
  To: G. Anthony Reina <reina@nsi.edu>; +Cc: pgsql-sql

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




^ permalink  raw  reply  [nested|flat] 9+ messages in thread

* Re: [SQL] What is the recommended machine configuration?
@ 1998-08-07 08:55  Johann Spies <jhspies@alpha.futurenet.co.za>
  parent: The Hermit Hacker <scrappy@hub.org>
  2 siblings, 0 replies; 9+ messages in thread

From: Johann Spies @ 1998-08-07 08:55 UTC (permalink / raw)
  To: The Hermit Hacker <scrappy@hub.org>; +Cc: G. Anthony Reina <reina@nsi.edu>; pgsql-sql

On Wed, 5 Aug 1998, The Hermit Hacker wrote:

> One thing in RedHat's favor, though, is that PostgreSQL comes with the
> operating system as an installable package...

That is also true of Debian Linux.

Johann

 --------------------------------------------------------------------------
| Johann Spies                                 Windsorlaan 19              |
| jhspies@alpha.futurenet.co.za                3201 Pietermaritzburg       |
| Tel/Faks Nr. +27 331-46-1310		       Suid-Afrika (South Africa)  |
 --------------------------------------------------------------------------

     "Do not be anxious about anything; but in every thing
      by prayer and supplication with thanksgiving let your
      requests be made known unto God."             
                              Philippians 4:6 




^ permalink  raw  reply  [nested|flat] 9+ messages in thread


end of thread, other threads:[~1998-08-07 08:55 UTC | newest]

Thread overview: 9+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
1998-08-05 20:01 What is the recommended machine configuration? G. Anthony Reina <reina@nsi.edu>
1998-08-05 20:52 ` pierre@desertmoon.com
1998-08-05 21:35 ` The Hermit Hacker <scrappy@hub.org>
1998-08-05 22:30   ` Brook Milligan <brook@trillium.NMSU.Edu>
1998-08-05 22:45     ` The Hermit Hacker <scrappy@hub.org>
1998-08-06 00:07   ` D'Arcy J.M. Cain <darcy@druid.net>
1998-08-06 12:20     ` Tom Good <tomg@nrnet.org>
1998-08-07 08:55   ` Johann Spies <jhspies@alpha.futurenet.co.za>
1998-08-06 14:38 ` Chris Johnson <cmj@inline-design.com>

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox