Re: disk performance benchmarks
Vivek Khera <khera@kcilink.com>
From: Vivek Khera <khera@kcilink.com>
To: pgsql-general@postgresql.org
Date: 2004-09-15T17:53:18Z
Lists: pgsql-performance, pgsql-general
>>>>> "JWB" == Jeffrey W Baker <jwbaker@acm.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@kciLink.com Rockville, MD +1-301-869-4449 x806 AIM: vivekkhera Y!: vivek_khera http://www.khera.org/~vivek/