Is it safe to disable log_checkpoints in postgres 15?

243 Views Asked by At

I've noticed that Postgres 15 has checkpoint enabled by default, and I'm curious about the rationale behind this decision, especially since it appears to be filling the log file with checkpoint messages and also is it safe to disable?

Reason and Is it safe to disable ?

1

There are 1 best solutions below

5
Laurenz Albe On BEST ANSWER

The reason can be seen from the commit message and the linked discussion. Remember that PostgreSQL is open source. The decision was not unanimous, but I think that two log message every five minutes are not too much, and I have got valuable clues from these messages in the past.

However, it is totally safe to disable log_checkpoints.