Re: Technical recommendations

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...

In response to

Browse pgsql-general by date

  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'