Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-performance by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group