From: "Jim Buttafuoco" <jim@contactbda.com>
To: "Simon Dale" <sdale@rm.com>, <pgsql-performance@postgresql.org>
Reply-To: jim@contactbda.com
Subject: Re: Quick Performance Poll
Date: Thu, 20 Apr 2006 09:36:25 -0400
Message-Id: <20060420133326.M88248@contactbda.com>
In-Reply-To: 
 <416F947BF5BA9E40B5F9AA649422212E0756199C@ex-mail2.internal.rmplc.net>
References: 
 <416F947BF5BA9E40B5F9AA649422212E0756199C@ex-mail2.internal.rmplc.net>
MIME-Version: 1.0
Content-Type: text/plain;
	charset=iso-8859-1


Simon,

I have many databases over 1T with the largest being ~6T.  All of my databases store telecom data, such as call detail
records.  The access is very fast when looking for a small subset of the data.  For servers, I am using white box intel
XEON and P4 systems with SATA disks, 4G of memory.  SCSI is out of our price range, but if I had unlimited $ I would go
with SCSI /SCSI raid instead.

Jim

---------- Original Message -----------
From: "Simon Dale" <sdale@rm.com>
To: <pgsql-performance@postgresql.org>
Sent: Thu, 20 Apr 2006 14:18:58 +0100
Subject: [PERFORM] Quick Performance Poll

> Hi,
> 
> I was just wondering whether anyone has had success with storing more
> than 1TB of data with PostgreSQL and how they have found the
> performance.
> 
> We need a database that can store in excess of this amount and still
> show good performance. We will probably be implementing several tables
> with foreign keys and also indexes which will obviously impact on both
> data size and performance too.
> 
> Many thanks in advance,
> 
> Simon
> Visit our Website at http://www.rm.com
> 
> This message is confidential. You should not copy it or disclose its contents to anyone. You may use and apply 
> the information for the intended purpose only. Internet communications are not secure; therefore, RM does not 
> accept legal responsibility for the contents of this message. Any views or opinions presented are those of the 
> author only and not of RM. If this email has come to you in error, please delete it, along with any 
> attachments. Please note that RM may intercept incoming and outgoing email communications.
> 
> Freedom of Information Act 2000
> This email and any attachments may contain confidential information belonging to RM.  Where the email and any 
> attachments do contain information of a confidential nature, including without limitation information relating 
> to trade secrets, special terms or prices these shall be deemed for the purpose of the Freedom of Information 
> Act 2000 as information provided in confidence by RM and the disclosure of which would be prejudicial to RM's 
> commercial interests.
> 
> This email has been scanned for viruses by Trend ScanMail.
------- End of Original Message -------