RE: LARGE db dump/restore for upgrade question

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

In response to

Browse pgsql-general by date

  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?