On Thu, 4 Jan 2007 15:00:05 -0300 "Charles A. Landemaine" <landemaine@xxxxxxxxx> wrote: > I'm building an e-mail service that has two requirements: It should > index messages on the fly to have lightening search results, and it > should be able to handle large amounts of space. The server is going > to be dedicated only for e-mail with 250GB of storage in Raid-5. I'd > like to know how PostgreSQL could handle such a large amount of data. > How much RAM would I need? I expect my users to have a 10GB quota per > e-mail account. Well this is a bit like asking "what's the top speed for a van that can carry 8 people", it really isn't enough information to be able to give you a good answer. It depends on everything from the data model you use to represent your E-mail messages, to configuration, to hardware speeds, etc. In general, you want as much RAM as you can afford for the project, the more the better. I'd say 2-4GB is the minimum. And RAID-5 isn't very good for database work in general, you'll get better performance from RAID 1+0. --------------------------------- Frank Wiles <frank@xxxxxxxxx> http://www.wiles.org ---------------------------------
