Re: PostgreSQL Configuration Tool for Dummies - Mailing list pgsql-performance

From Richard Huxton
Subject Re: PostgreSQL Configuration Tool for Dummies
Date
Msg-id 46780DE4.1010007@archonet.com
Whole thread Raw
In response to Re: PostgreSQL Configuration Tool for Dummies  ("Campbell, Lance" <lance@uiuc.edu>)
List pgsql-performance
Campbell, Lance wrote:
> Francisco and Richard,
> Why ask about disk or raid?  How would that impact any settings in
> postgresql.conf?

Well, random_page_cost will depend on how fast your disk system can
locate a non-sequential page. If you have a 16-disk RAID-10 array that's
noticably less time than a single 5400rpm IDE in a laptop.

> I did forget the obvious question:
>
> What OS are you using?

Tricky to keep simple, isn't it :-)

--
   Richard Huxton
   Archonet Ltd

pgsql-performance by date:

Previous
From: Richard Huxton
Date:
Subject: Re: Maintenance question / DB size anomaly...
Next
From: PFC
Date:
Subject: Re: PostgreSQL Configuration Tool for Dummies