From donv@webimpact.com Thu May 6 13:46:48 2004 X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.2]) by svr1.postgresql.org (Postfix) with ESMTP id 579C6D1EAFA for ; Thu, 6 May 2004 10:46:48 -0300 (ADT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (neptune.hub.org [200.46.204.2]) (amavisd-new, port 10024) with ESMTP id 76415-02 for ; Thu, 6 May 2004 10:46:30 -0300 (ADT) Received: from mta0.beanfield.net (unknown [66.207.192.6]) by svr1.postgresql.org (Postfix) with ESMTP id D88FBD1B507 for ; Thu, 6 May 2004 10:46:25 -0300 (ADT) Received: from don.webimpact.com (66-207-218-34.beanfield.net [66.207.218.34] (may be forged)) by mta0.beanfield.net (8.12.11/8.12.6) with ESMTP id i46DkSKF052436 for ; Thu, 6 May 2004 09:46:28 -0400 (EDT) (envelope-from donv@webimpact.com) Message-Id: <6.1.0.6.0.20040506094353.01b363c8@localhost> X-Sender: donv@web-impact.com@localhost X-Mailer: QUALCOMM Windows Eudora Version 6.1.0.6 Date: Thu, 06 May 2004 09:47:08 -0400 To: pgsql-performance@postgresql.org From: Don Vaillancourt Subject: Re: [OFF-TOPIC] - Known maximum size of the In-Reply-To: <4099F396.2020103@archonet.com> References: <034d01c44b2e$ae9b2b00$cf00a8c0@smannote> <1083791489.11496.23.camel@localhost.localdomain> <4099996E.90903@familyhealth.com.au> <4099F396.2020103@archonet.com> Mime-Version: 1.0 Content-Type: multipart/alternative; boundary="=====================_237368781==.ALT" X-Virus-Scanned: by amavisd-new at postgresql.org X-Spam-Status: No, hits=0.7 tagged_above=0.0 required=5.0 tests=HTML_20_30, HTML_FONTCOLOR_BLUE, HTML_FONT_BIG, HTML_MESSAGE X-Spam-Level: X-Archive-Number: 200405/49 X-Sequence-Number: 6880 --=====================_237368781==.ALT Content-Type: text/plain; charset="us-ascii"; format=flowed Here's a question a little off-topic. What would a 32TB database hardware configuration look like. I'm assuming 200GB hard-drives which would total 160 of them. Double that if you mirror them. Am I correct? At 04:13 AM 06/05/2004, you wrote: >Christopher Kings-Lynne wrote: >>>>What's the case of bigger database PostgreSQL (so greate and amount of >>>>registers) that they know??? >> >>Didn't someone say that RedSheriff had a 10TB postgres database or something? > > From http://www.redsheriff.com/us/news/news_4_201.html > >"According to the company, RedSheriff processes 10 billion records a month >and the total amount of data managed is more than 32TB. Griffin said >PostgreSQL has been in production for 12 months with not a single database >fault in that time "The stability of the database can not be questioned. >Needless to say, we are extremely happy." > >I think it's safe to assume this is not on a spare Dell 600SC though. > >-- > Richard Huxton > Archonet Ltd > >---------------------------(end of broadcast)--------------------------- >TIP 7: don't forget to increase your free space map settings Don Vaillancourt Director of Software Development WEB IMPACT INC. 416-815-2000 ext. 245 email: donv@webimpact.com web: http://www.webimpact.com This email message is intended only for the addressee(s) and contains information that may be confidential and/or copyright. If you are not the intended recipient please notify the sender by reply email and immediately delete this email. Use, disclosure or reproduction of this email by anyone other than the intended recipient(s) is strictly prohibited. No representation is made that this email or any attachments are free of viruses. Virus scanning is recommended and is the responsibility of the recipient. --=====================_237368781==.ALT Content-Type: text/html; charset="us-ascii"
Here's a question a little off-topic.

What would a 32TB database hardware configuration look like.  I'm assuming 200GB hard-drives which would total 160 of them.  Double that if you mirror them.

Am I correct?

At 04:13 AM 06/05/2004, you wrote:
Christopher Kings-Lynne wrote:
What's the case of bigger database PostgreSQL (so greate and amount of
registers) that they know???

Didn't someone say that RedSheriff had a 10TB postgres database or something?

From http://www.redsheriff.com/us/news/news_4_201.html

"According to the company, RedSheriff processes 10 billion records a month and the total amount of data managed is more than 32TB. Griffin said PostgreSQL has been in production for 12 months with not a single database fault in that time “The stability of the database can not be questioned. Needless to say, we are extremely happy."

I think it's safe to assume this is not on a spare Dell 600SC though.

--
  Richard Huxton
  Archonet Ltd

---------------------------(end of broadcast)---------------------------
TIP 7: don't forget to increase your free space map settings

Don Vaillancourt
Director of Software Development

WEB IMPACT INC.
416-815-2000 ext. 245
email: donv@webimpact.com
web:
http://www.webimpact.com



This email message is intended only for the addressee(s) 
and contains information that may be confidential and/or 
copyright.  If you are not the intended recipient please 
notify the sender by reply email and immediately delete 
this email. Use, disclosure or reproduction of this email 
by anyone other than the intended recipient(s) is strictly 
prohibited. No representation is made that this email or 
any attachments are free of viruses. Virus scanning is 
recommended and is the responsibility of the recipient.












--=====================_237368781==.ALT--




From mendola@bigfoot.com Fri May  7 23:47:10 2004
X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org
Received: from localhost (unknown [200.46.204.2])
	by svr1.postgresql.org (Postfix) with ESMTP id 6C57BD1E9C7
	for ;
	Fri,  7 May 2004 20:47:10 -0300 (ADT)
Received: from svr1.postgresql.org ([200.46.204.71])
	by localhost (neptune.hub.org [200.46.204.2]) (amavisd-new, port 10024)
	with ESMTP id 70664-07
	for ;
	Fri,  7 May 2004 20:46:53 -0300 (ADT)
Received: from news.hub.org (news.hub.org [200.46.204.72])
	by svr1.postgresql.org (Postfix) with ESMTP id 22AF5D1EE73
	for ;
	Fri,  7 May 2004 20:46:50 -0300 (ADT)
Received: from news.hub.org (news.hub.org [200.46.204.72])
	by news.hub.org (8.12.9/8.12.9) with ESMTP id i47NkkSx041426
	for ; Fri, 7 May 2004 23:46:46 GMT
	(envelope-from news@news.hub.org)
Received: (from news@localhost)
	by news.hub.org (8.12.9/8.12.9/Submit) id i47NZrt8023405
	for pgsql-performance@postgresql.org; Fri, 7 May 2004 23:35:53 GMT
From: Gaetano Mendola 
X-Newsgroups: comp.databases.postgresql.performance
Subject: Re: [OFF-TOPIC] - Known maximum size of the
Date: Sat, 08 May 2004 01:35:44 +0200
Organization: PYRENET Midi-pyrenees Provider
Lines: 25
Message-ID: <409C1D50.4010602@bigfoot.com>
References: <034d01c44b2e$ae9b2b00$cf00a8c0@smannote>
	<1083791489.11496.23.camel@localhost.localdomain>
	<4099996E.90903@familyhealth.com.au>
	<4099F396.2020103@archonet.com>
	<6.1.0.6.0.20040506094353.01b363c8@localhost>
Mime-Version: 1.0
Content-Type: text/plain; charset=us-ascii; format=flowed
Content-Transfer-Encoding: 7bit
X-Complaints-To: abuse@pyrenet.fr
To: Don Vaillancourt 
User-Agent: Mozilla Thunderbird 0.6 (Windows/20040502)
X-Accept-Language: en-us, en
In-Reply-To: <6.1.0.6.0.20040506094353.01b363c8@localhost>
To: pgsql-performance@postgresql.org
X-Virus-Scanned: by amavisd-new at postgresql.org
X-Spam-Status: No, hits=0.0 tagged_above=0.0 required=5.0 tests=
X-Spam-Level: 
X-Archive-Number: 200405/55
X-Sequence-Number: 6886

Don Vaillancourt wrote:

> 
> Here's a question a little off-topic.
> 
> What would a 32TB database hardware configuration look like.  I'm 
> assuming 200GB hard-drives which would total 160 of them.  Double that 
> if you mirror them.
> 
> Am I correct?

Why do you have to mirror them ? Usually a SAN make data redundancy
using a RAID 4 or 5, this depend if you need read performances or
write performances, in the case of Red Sherif I guess that guys are
using RAID 50 ( 0 + 5 ) sets so what you "waste" is a disk for each
set.



Regards
Gaetano Mendola