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 -------