Re: disk performance benchmarks

From: Vivek Khera <khera(at)kcilink(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: disk performance benchmarks
Date: 2004-09-15 17:53:18
Message-ID: x73c1jctbl.fsf@yertle.int.kciLink.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general pgsql-performance

>>>>> "JWB" == Jeffrey W Baker <jwbaker(at)acm(dot)org> writes:

JWB> All these replies are really interesting, but the point is not that my
JWB> RAIDs are too slow, or that my CPUs are too slow. My point is that, for
JWB> long stretches of time, by database doesn't come anywhere near using the
JWB> capacity of the hardware. And I think that's odd and would like to
JWB> config it to "false".

Have you tried to increase your checkpoing_segments? I get the
suspicion that you're checkpointing every 3 minutes constantly.
You'll have to restart the postmaster for this setting to take effect,
I believe.

--
=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
Vivek Khera, Ph.D. Khera Communications, Inc.
Internet: khera(at)kciLink(dot)com Rockville, MD +1-301-869-4449 x806
AIM: vivekkhera Y!: vivek_khera http://www.khera.org/~vivek/

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message David Fetter 2004-09-15 17:54:34 Re: division by zero issue
Previous Message Vivek Khera 2004-09-15 17:51:38 Re: disk performance benchmarks

Browse pgsql-performance by date

  From Date Subject
Next Message Ron St-Pierre 2004-09-15 17:55:21 Re: [GENERAL] disk performance benchmarks
Previous Message Vivek Khera 2004-09-15 17:51:38 Re: disk performance benchmarks