Re: Checkpoint Tuning Question - Mailing list pgsql-general

From Tom Lane
Subject Re: Checkpoint Tuning Question
Date
Msg-id 22424.1247236061@sss.pgh.pa.us
Whole thread Raw
In response to Re: Checkpoint Tuning Question  (Simon Riggs <simon@2ndQuadrant.com>)
Responses Re: Checkpoint Tuning Question
List pgsql-general
Simon Riggs <simon@2ndQuadrant.com> writes:
> ISTM more likely to be a problem with checkpointing clog or subtrans.
> That would block everybody and the scale of the problem is about right.

That's what I had been thinking too, but the log_checkpoint output
conclusively disproves it: those steps are taking less than 20msec.

            regards, tom lane

pgsql-general by date:

Previous
From: "Hiroshi Saito"
Date:
Subject: Re: psql language
Next
From: nabble.30.miller_2555@spamgourmet.com
Date:
Subject: Re: Database storage