Re: PostgreSQL Configuration Tool for Dummies

From: Richard Huxton <dev(at)archonet(dot)com>
To: "Campbell, Lance" <lance(at)uiuc(dot)edu>
Cc: Francisco Reyes <lists(at)stringsutils(dot)com>, pgsql-performance(at)postgresql(dot)org
Subject: Re: PostgreSQL Configuration Tool for Dummies
Date: 2007-06-19 17:09:56
Message-ID: 46780DE4.1010007@archonet.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message PFC 2007-06-19 17:12:33 Re: PostgreSQL Configuration Tool for Dummies
Previous Message Richard Huxton 2007-06-19 17:04:50 Re: Maintenance question / DB size anomaly...