Re: Sustained inserts per sec ... ? - Mailing list pgsql-performance

From Tom Lane
Subject Re: Sustained inserts per sec ... ?
Date
Msg-id 28517.1112389125@sss.pgh.pa.us
Whole thread Raw
In response to Re: Sustained inserts per sec ... ?  (Christopher Petrilli)
List pgsql-performance
Christopher Petrilli <> 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

pgsql-performance by date:

Previous
From: "Joshua D. Drake"
Date:
Subject: Re: Sustained inserts per sec ... ?
Next
From: Christopher Petrilli
Date:
Subject: Re: Sustained inserts per sec ... ?