From: | "Andrew Snow" <andrew(at)modulus(dot)org> |
---|---|
To: | "Philip Crotwell" <crotwell(at)seis(dot)sc(dot)edu> |
Cc: | <pgsql-general(at)postgresql(dot)org> |
Subject: | RE: LARGE db dump/restore for upgrade question |
Date: | 2001-08-15 03:14:10 |
Message-ID: | JEEGIJPOJIGGIIHGKOKOMEEGDLAA.andrew@modulus.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
> Any suggestion on how to prepare for the next upgrade would be
> appreciated.
I think it has to be said that if you want decent performance on excessively
large (50GB+) databases, you're going to need excessively good hardware to
operate it on. Buy a 3ware IDE RAID controller (www.hypermicro.com) and a
stripe a couple of seagate 80GB IDE drives (the new ones have an awesome
transfer rate). Turn of fsync, and use softupdates or even async I/O.
I am guessing though you've already done all of the above. You might have
to go beefier hardware, for PCs that means DDR SDRAM/Rambus, and a 64 bit
PCI 3ware card with 4 or 8 hard drives.
Hope that helps
Andrew
From | Date | Subject | |
---|---|---|---|
Next Message | newsreader | 2001-08-15 03:28:47 | Re: I am confused about PointerGetDatum among other things |
Previous Message | Robert J. Sanford, Jr. | 2001-08-15 03:05:30 | RE: why no stored procedures? |