postgresqlpostgres15

Is it safe to disable log_checkpoints in postgres 15?


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 ?


Solution

  • 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.