Emit "checkpoint skipped because system is idle" message at LOG level if log_checkpoints is set - Mailing list pgsql-hackers

From Bharath Rupireddy
Subject Emit "checkpoint skipped because system is idle" message at LOG level if log_checkpoints is set
Date
Msg-id CALj2ACX9LPadCNACDZ3JykDT-6sfPrPchXTLyNHP3cbwyJYjsg@mail.gmail.com
Whole thread Raw
Responses Re: Emit "checkpoint skipped because system is idle" message at LOG level if log_checkpoints is set
List pgsql-hackers
Hi,

Postgres server emits a message at DEBUG1 level when it skips a
checkpoint. At times, developers might be surprised after figuring out
from server logs that there were no checkpoints happening at all
during a certain period of time when DEBUG1 messages aren't captured.
How about emitting the message at LOG level if log_checkpoints is set?
Patch attached.

Thoughts?

Regards,
Bharath Rupireddy.

Attachment

pgsql-hackers by date:

Previous
From: "Andrey V. Lepikhov"
Date:
Subject: Re: pg_stat_statements and "IN" conditions
Next
From: Alexander Lakhin
Date:
Subject: Re: Index-only scan for btree_gist turns bpchar to char