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