I am running EAStress workload.. which doesnt do manual checkpoints as
far as I know..
I will turn on checkpoint_logging to get more idea as Heikki suggested
thanks.
-Jignesh
Tom Lane wrote:
> "Jignesh K. Shah" <J(dot)K(dot)Shah(at)Sun(dot)COM> writes:
>
>> I am running tests with PG8.3b2 on Solaris 10 8/07 and I still see IO
>> flood when checkpoint happens.
>>
>
> I am thinking that you are probably trying to test that by issuing
> manual CHECKPOINT commands. A manual checkpoint is still done at full
> speed, as are shutdown checkpoints. You need to study the behavior of
> automatic (background) checkpoints, instead.
>
> regards, tom lane
>