> > Most clients will be interested in say the last 7 days worth of data?
> > Great.. Start out with 4GB ram on a good Dual CPU -- Opterons seem to
> > work quite well -- and make sure the motherboard can hold double that in
> > memory for an upgrade sometime next year when you've become popular.
On Wed, 2003-11-12 at 22:35, Rod Taylor wrote:
> You may want to consider keeping the compressed email in a separate
> table than the information describing it. It would mean descriptive
> information is more likely to be in RAM, where the body probably doesn't
> matter as much (you view them 1 at
> > How much in total storage? If you have (or will have) > ~6 disks, go
> > for RAID 5 otherwise 10 is probably appropriate.
>
> I'm not sure but I believe there are about 6-8 10K scsi drives on the
> system. There is quite a bit of storage to spare currently so I think
I see.. With 8 drives
On Wed, 2003-11-12 at 16:29, Neil Conway wrote:
> Suchandra Thapa <[EMAIL PROTECTED]> writes:
> > I was thinking using about using a raid 1+0 array to hold the
> > database but since I can use different array types, would it be
> > better to use 1+0 for the wal logs and a raid 5 for the database?
>
Suchandra Thapa <[EMAIL PROTECTED]> writes:
> I was thinking using about using a raid 1+0 array to hold the
> database but since I can use different array types, would it be
> better to use 1+0 for the wal logs and a raid 5 for the database?
It has been recommended on this list that getting a RAID
On Wed, 2003-11-12 at 12:23, Rod Taylor wrote:
> On Wed, 2003-11-12 at 12:34, Suchandra Thapa wrote:
> > I'm moving a webmail service over to use a postgresql database for
> > storage and wanted to get any tips for optimizing performance. The
> > machine will be a multiprocessor (either 2 or 4 cpu
On Wed, 2003-11-12 at 12:34, Suchandra Thapa wrote:
> I'm moving a webmail service over to use a postgresql database for
> storage and wanted to get any tips for optimizing performance. The
> machine will be a multiprocessor (either 2 or 4 cpu ) system with a raid
> array. What layout should be u
I'm moving a webmail service over to use a postgresql database for
storage and wanted to get any tips for optimizing performance. The
machine will be a multiprocessor (either 2 or 4 cpu ) system with a raid
array. What layout should be used? I was thinking using about using a
raid 1+0 array to h