From: Joshua D. Drake <jd@commandprompt.com>
To: Charles A. Landemaine <landemaine@gmail.com>
Cc: pgsql-performance@postgresql.org
Subject: Re: PostgreSQL to host e-mail?
Date: Thu, 04 Jan 2007 10:11:45 -0800
Message-ID: <1167934305.18376.15.camel@localhost.localdomain> (raw)
In-Reply-To: <e6575a30701041000u64d3c8c1sff6590724c264278@mail.gmail.com>
References: <e6575a30701041000u64d3c8c1sff6590724c264278@mail.gmail.com>
On Thu, 2007-01-04 at 15:00 -0300, Charles A. Landemaine 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.
Well Raid 5 is likely a mistake. Consider RAID 10.
> I'd
> like to know how PostgreSQL could handle such a large amount of data.
250GB is not really that much data for PostgreSQL I have customers with
much larger data sets.
> How much RAM would I need?
Lots... which is about all I can tell you without more information. How
many customers? Are you using table partitioning? How will you be
searching? Full text or regex?
Joshua D. Drake
> I expect my users to have a 10GB quota per
> e-mail account.
> Thanks for your advice,
>
--
=== The PostgreSQL Company: Command Prompt, Inc. ===
Sales/Support: +1.503.667.4564 || 24x7/Emergency: +1.800.492.2240
Providing the most comprehensive PostgreSQL solutions since 1997
http://www.commandprompt.com/
Donate to the PostgreSQL Project: http://www.postgresql.org/about/donate
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: jd@commandprompt.com, landemaine@gmail.com
Subject: Re: PostgreSQL to host e-mail?
In-Reply-To: <1167934305.18376.15.camel@localhost.localdomain>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox