Configuration and monitoring

Server parameters can be adjusted per user/database combination. When the postgresql.conf file is reloaded via pg_ctl reload or sending the server a SIGHUP signal, the server log file notes which parameters were changed as a result. Background writer statistics can now be reset using pg_stat_reset_shared('bgwriter').

Table and function counters can be individually reset using the pg_stat_reset_single_table_counters() and pg_stat_reset_single_function_counters() functions. The log_temp_files parameter is now specified in kilobyte units and its documentation is corrected. The description in earlier versions was misleading.

The log_line_prefix option can now track the SQLSTATE value set for messages such as errors, ...

Get PostgreSQL 10 High Performance now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.