We're still learning to tune PostgreSQL for our production setup, and over
the weekend we saw a huge spike in INSERT/UPDATE completion time for a
short period which turned out to correlate to an oversized checkpoint. I've
included the preceding and following checkpoints for reference points, as
the
On Mon, Jun 16, 2014 at 5:01 PM, Jeff Janes wrote:
> On Mon, Jun 16, 2014 at 12:40 PM, Nathaniel Talbott
> wrote:
> >> So the fsync (by the kernel) of a single file took 64 seconds. This
> >> single event explains almost all of the overrun and the performance
> >&g
