From: Michael Monnerie <michael.monnerie@it-management.at>
Organization: it-management http://it-management.at
To: Thomas =?iso-8859-15?q?Br=E4utigam?= <thomas.braeutigam@nexustelecom.com>
Subject: Re: Postgres and SUN
Date: Tue, 1 Apr 2008 14:54:16 +0200
User-Agent: KMail/1.9.6 (enterprise 20070904.708012)
References: <46F5921DF52F6E40860287B30CADADC7776709@EROS.nexus-ag.com>
	<200804011204.10351@zmi.at>
	<46F5921DF52F6E40860287B30CADADC7776728@EROS.nexus-ag.com>
In-Reply-To: <46F5921DF52F6E40860287B30CADADC7776728@EROS.nexus-ag.com>
Cc: pgsql-admin@postgresql.org
MIME-Version: 1.0
Content-Type: multipart/signed; boundary="nextPart3307744.Qu929vIc5T";
	protocol="application/pgp-signature"; micalg=pgp-sha1
Content-Transfer-Encoding: 7bit
Message-Id: <200804011454.16613@zmi.at>

--nextPart3307744.Qu929vIc5T
Content-Type: text/plain;
  charset="iso-8859-15"
Content-Transfer-Encoding: quoted-printable
Content-Disposition: inline

=46irst, please keep the discussion on the mailinglist.

On Dienstag, 1. April 2008 Thomas Br=E4utigam 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=20
information to make some statistics, it wouldn't matter too much if a=20
query takes 50 minutes or 60 minutes. If it's like a broker online=20
system a single query should optimally take <1ms ;-)

Do you have that db already, and on which hardware. Does it perform=20
well? The best is to have a "normal" machine filled with the data to=20
see if you need more. It can be surprising how many transactions/s a=20
simple AMD dual core with 8GB RAM and a cheap SATA RAID with 16x10krpm=20
WD Raptor disks can handle. Probably you can buy such a test machine,=20
shouldn't cost more than 3000=A4, and it's good for a first idea how much=20
you need. And if it's too slow, you'll have an estimation of how much=20
more power you need. This can save a *lot* of money, as Sun's aren't=20
the cheapest iron around, so a smaller model probably saves a lot more=20
money than this test machine.=20

mfg zmi
=2D-=20
// 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

--nextPart3307744.Qu929vIc5T
Content-Type: application/pgp-signature; name=signature.asc 
Content-Description: This is a digitally signed message part.

-----BEGIN PGP SIGNATURE-----
Version: GnuPG v2.0.4-svn0 (GNU/Linux)

iD8DBQBH8jB4zhSR9xwSCbQRAm/WAKCgLLz1M2MDZQtuaaP6oWfCsrZdgACgzIq1
7doDRnqmjlv5/IUohQ2p+AY=
=Y3Ql
-----END PGP SIGNATURE-----

--nextPart3307744.Qu929vIc5T--