"Jay Greenfield" <jag@xxxxxxxxxxxxx> writes: > I did a run with checkpoint_segments @ 30 (from 3 in 4.35 min run) and > posted a time of 6.78 minutes. Any idea why this would increase the time? The first time through might take longer while the machine creates empty xlog segment files (though I'd not have expected a hit that big). Once it's fully populated pg_xlog it'll just recycle the files, so you might find that a second try is faster. regards, tom lane