From: Jason Hihn <jhihn@paytimepayroll.com>
To: pgsql-performance@postgresql.org
Subject: Shopping for hardware
Date: Mon, 06 Oct 2003 11:17:00 -0400
Message-ID: <NGBBLHANMLKMHPDGJGAPGEPECNAA.jhihn@paytimepayroll.com> (raw)
Ok, I asked this on [novice], but I was told it's be better to post it
here...
I've got some money to spend on a new servers. The biggest concern is the
PostgreSQL database server that will "be the company." (*Everyone* uses the
database server in some form or another) I'm looking for hot-swappable RAID
1 on a Linux platform at the least. Are there any vendors to avoid or
prefer? What works best? Am I better off going with a DIY or getting
something pre-packaged?
In terms of numbers, we expect have an average of 100 active connections
(most of which are idle 9/10ths of the time), with about 85% reading
traffic. I hope to have one server host about 1000-2000 active databases,
with the largest being about 60 meg (no blobs). Inactive databases will only
be for reading (archival) purposes, and will seldom be accessed. (I could
probably move them off to another server with a r/o disk...)
Does any of this represent a problem for Postgres? The datasets are
typically not that large, only a few queries on a few databases ever return
over 1000 rows.
The configuration that is going on in my head is:
RAID 1, 200gig disks
1 server, 4g ram
Linux 2.4 or 2.6 (depends on when we deploy and 2.6's track record at that
time)
I want something that can do hot-swaps and auto-mirroring after swap.
Unfortunately, this is a new area for me. (I normally stick to S/W for
non-high end systems)
Thanks!
Jason Hihn
Paytime Payroll
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients from your mail client; the link fills in
the headers below: reply via email
Some clients, webmail especially, drop In-Reply-To and References from
a link, and the reply then starts a new thread: use the mbox below.
To: pgsql-performance@postgresql.org
Cc: jhihn@paytimepayroll.com
Subject: Re: Shopping for hardware
In-Reply-To: <NGBBLHANMLKMHPDGJGAPGEPECNAA.jhihn@paytimepayroll.com>
References: <NGBBLHANMLKMHPDGJGAPGEPECNAA.jhihn@paytimepayroll.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
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