Re: LDC - Load Distributed Checkpoints with PG8.3b2 on Solaris - Mailing list pgsql-hackers

From Jignesh K. Shah
Subject Re: LDC - Load Distributed Checkpoints with PG8.3b2 on Solaris
Date
Msg-id 4739D75C.1050407@sun.com
Whole thread Raw
In response to Re: LDC - Load Distributed Checkpoints with PG8.3b2 on Solaris  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: LDC - Load Distributed Checkpoints with PG8.3b2 on Solaris  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-hackers
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.K.Shah@Sun.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
>   


pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: LDC - Load Distributed Checkpoints with PG8.3b2 on Solaris
Next
From: Doug Knight
Date:
Subject: Windows psql -f load of files with tabs changing to escape sequences