pg.ddx.io pgsql-sql@postgresql.org mailing list archive
help / color / mirror / Atom feedWhat 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>
1998-08-05 20:52 ` Re: [SQL] What is the recommended machine configuration? pierre@desertmoon.com
1998-08-05 21:35 ` Re: [SQL] What is the recommended machine configuration? The Hermit Hacker <scrappy@hub.org>
1998-08-06 14:38 ` Re: [SQL] What is the recommended machine configuration? Chris Johnson <cmj@inline-design.com>
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:01 What is the recommended machine configuration? G. Anthony Reina <reina@nsi.edu>
@ 1998-08-05 20:52 ` pierre@desertmoon.com
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 20:01 What is the recommended machine configuration? G. Anthony Reina <reina@nsi.edu>
@ 1998-08-05 21:35 ` The Hermit Hacker <scrappy@hub.org>
1998-08-05 22:30 ` Re: [SQL] What is the recommended machine configuration? Brook Milligan <brook@trillium.NMSU.Edu>
1998-08-06 00:07 ` Re: [SQL] What is the recommended machine configuration? D'Arcy J.M. Cain <darcy@druid.net>
1998-08-07 08:55 ` Re: [SQL] What is the recommended machine configuration? Johann Spies <jhspies@alpha.futurenet.co.za>
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 20:01 What is the recommended machine configuration? G. Anthony Reina <reina@nsi.edu>
1998-08-05 21:35 ` Re: [SQL] What is the recommended machine configuration? The Hermit Hacker <scrappy@hub.org>
@ 1998-08-05 22:30 ` Brook Milligan <brook@trillium.NMSU.Edu>
1998-08-05 22:45 ` Re: [SQL] What is the recommended machine configuration? 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 20:01 What is the recommended machine configuration? G. Anthony Reina <reina@nsi.edu>
1998-08-05 21:35 ` Re: [SQL] What is the recommended machine configuration? The Hermit Hacker <scrappy@hub.org>
1998-08-05 22:30 ` Re: [SQL] What is the recommended machine configuration? Brook Milligan <brook@trillium.NMSU.Edu>
@ 1998-08-05 22:45 ` The Hermit Hacker <scrappy@hub.org>
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-05 20:01 What is the recommended machine configuration? G. Anthony Reina <reina@nsi.edu>
1998-08-05 21:35 ` Re: [SQL] What is the recommended machine configuration? The Hermit Hacker <scrappy@hub.org>
@ 1998-08-06 00:07 ` D'Arcy J.M. Cain <darcy@druid.net>
1998-08-06 12:20 ` Re: [SQL] What is the recommended machine configuration? Tom Good <tomg@nrnet.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-05 20:01 What is the recommended machine configuration? G. Anthony Reina <reina@nsi.edu>
1998-08-05 21:35 ` Re: [SQL] What is the recommended machine configuration? The Hermit Hacker <scrappy@hub.org>
1998-08-06 00:07 ` Re: [SQL] What is the recommended machine configuration? D'Arcy J.M. Cain <darcy@druid.net>
@ 1998-08-06 12:20 ` Tom Good <tomg@nrnet.org>
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-05 20:01 What is the recommended machine configuration? G. Anthony Reina <reina@nsi.edu>
1998-08-05 21:35 ` Re: [SQL] What is the recommended machine configuration? The Hermit Hacker <scrappy@hub.org>
@ 1998-08-07 08:55 ` Johann Spies <jhspies@alpha.futurenet.co.za>
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
* Re: [SQL] What is the recommended machine configuration?
1998-08-05 20:01 What is the recommended machine configuration? G. Anthony Reina <reina@nsi.edu>
@ 1998-08-06 14:38 ` Chris Johnson <cmj@inline-design.com>
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
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