| From: | "Scott Marlowe" <smarlowe(at)qwest(dot)net> |
|---|---|
| To: | "William Yu" <wyu(at)talisys(dot)com> |
| Cc: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: Technical recommendations |
| Date: | 2004-08-30 15:37:34 |
| Message-ID: | 1093880254.5493.37.camel@localhost.localdomain |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On Mon, 2004-08-30 at 05:48, William Yu wrote:
> Francois Suter wrote:
> > I have received via the Advocacy questions about optimising a database
> > server using PostgreSQL. The people asking the questions are planning to
> > buy a new machine, solely dedicated to serving PostgreSQL. Being no
> > specialist of optimisation, could someone help?
SNIP
> > What other components should they bet strongly on: RAM, HD, network card?
>
> High read activity -- a ton of RAM. High write activity -- a kickass
> SCSI RAID-0/1 config.
Don't forget the battery backed cache on the controller...
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Elie Nacache | 2004-08-30 15:43:31 | Hebrew support -- please help ! |
| Previous Message | Tom Lane | 2004-08-30 15:33:08 | Re: timestamp and date behaviour with '-infinity' |