Christopher Petrilli <petrilli@gmail.com> writes:
> What seems to happen is it slams into a "wall" of some sort, the
> system goes into disk write frenzy (wait=90% CPU), and eventually
> recovers and starts running for a while at a more normal speed.
Checkpoint maybe? If so, tweaking the bgwriter parameters might
improve matters.
regards, tom lane