Re: Checkpoint cost, looks like it is WAL/CRC - Mailing list pgsql-hackers

From Josh Berkus
Subject Re: Checkpoint cost, looks like it is WAL/CRC
Date
Msg-id 200507221323.38405.josh@agliodbs.com
Whole thread Raw
In response to Re: Checkpoint cost, looks like it is WAL/CRC  (Greg Stark <gsstark@mit.edu>)
List pgsql-hackers
Greg,

> For any benchmarking to be meaningful you have to set the checkpoint
> interval to something more realistic. Something like 5 minutes. That way
> when the final checkpoint cycle isn't completely included in the timing
> data you'll at least be missing a statistically insignificant portion of
> the work.

Look at the PDF I sent.    This was run with 5, 10, and 30 minutes.   

-- 
--Josh

Josh Berkus
Aglio Database Solutions
San Francisco


pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: Checkpoint cost, looks like it is WAL/CRC
Next
From: Josh Berkus
Date:
Subject: Re: Checkpoint cost, looks like it is WAL/CRC