From: Michael Monnerie <michael.monnerie@it-management.at>
To: Thomas Bräutigam <thomas.braeutigam@nexustelecom.com>
Cc: pgsql-admin@postgresql.org
Subject: Re: Postgres and SUN
Date: Tue, 1 Apr 2008 14:54:16 +0200
Message-ID: <200804011454.16613@zmi.at> (raw)
In-Reply-To: <46F5921DF52F6E40860287B30CADADC7776728@EROS.nexus-ag.com>
References: <46F5921DF52F6E40860287B30CADADC7776709@EROS.nexus-ag.com>
<200804011204.10351@zmi.at>
<46F5921DF52F6E40860287B30CADADC7776728@EROS.nexus-ag.com>
First, please keep the discussion on the mailinglist.
On Dienstag, 1. April 2008 Thomas Bräutigam wrote:
> What is "huge"
> The DB Size is between 500 GB and 2 Terra, mostly over 1 Terra.
Over 1 Tera is kinda huge, I'd say :-)
> I looked at the Fire V490
> One to three User are necessary
> I don't know the exact transacations per second, but the most of the
> jobs the database have to do is that we have a high amount of
> inserations and deletions in the database.
> What do you mean with what kind of Database?
If it's an offline like application where you just need to store lots of
information to make some statistics, it wouldn't matter too much if a
query takes 50 minutes or 60 minutes. If it's like a broker online
system a single query should optimally take <1ms ;-)
Do you have that db already, and on which hardware. Does it perform
well? The best is to have a "normal" machine filled with the data to
see if you need more. It can be surprising how many transactions/s a
simple AMD dual core with 8GB RAM and a cheap SATA RAID with 16x10krpm
WD Raptor disks can handle. Probably you can buy such a test machine,
shouldn't cost more than 3000€, and it's good for a first idea how much
you need. And if it's too slow, you'll have an estimation of how much
more power you need. This can save a *lot* of money, as Sun's aren't
the cheapest iron around, so a smaller model probably saves a lot more
money than this test machine.
mfg zmi
--
// Michael Monnerie, Ing.BSc ----- http://it-management.at
// Tel: 0676/846 914 666 .network.your.ideas.
// PGP Key: "curl -s http://zmi.at/zmi.asc | gpg --import"
// Fingerprint: AC19 F9D5 36ED CD8A EF38 500E CE14 91F7 1C12 09B4
// Keyserver: www.keyserver.net Key-ID: 1C1209B4
Attachments:
signature.asc (application/pgp-signature, 193B) download
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 using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: michael.monnerie@it-management.at, thomas.braeutigam@nexustelecom.com
Subject: Re: Postgres and SUN
In-Reply-To: <200804011454.16613@zmi.at>
* 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