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@xxxxxx> To: <pgsql-performance@xxxxxxxxxxxxxx> 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 -------
