On 17th of February, Joe Conway committed patch: Add new system view, pg_config Move and refactor the underlying code for the pg_config client application to src/common in support of sharing it with a new system information SRF called pg_config() which makes the same information available ...

On 15th of May, Peter Eisentraut committed patch: Add pg_settings.pending_restart column with input from David G. Johnston, Robert Haas, Michael Paquier

On 23rd of February, Heikki Linnakangas committed patch: Replace checkpoint_segments with min_wal_size and max_wal_size. Instead of having a single knob (checkpoint_segments) that both triggers checkpoints, and determines how many checkpoints to recycle, they are now separate concerns. There is still an internal variable called CheckpointSegments, ...

On 18th of December, Tatsuo Ishii committed patch: Add ALTER SYSTEM command to edit the server configuration file. Patch contributed by Amit Kapila. Reviewed by Hari Babu, Masao Fujii, Boszormenyi Zoltan, Andres Freund, Greg Smith and others. On the next day, Fujii Masao committed ...

While there are some docs on it, I decided to write about it, in perhaps more accessible language - not as a developer, but as PostgreSQL user. Some parts (quite large parts) were described in one of my earlier posts, but ...

For todays post in Understanding postgresql.conf series, I chose work_mem parameter.

Starting new blog series - explanation of various configuration parameters. I will of course follow no schedule or order - if I'd had to - it would be my job, and in this way - it's fun. First configuration parameter to write ...

On 7th of October Alvaro Herrera committed his own patch, which adds quite interesting possibilty: Log Message: ----------- Make it possibly to specify GUC params per user and per database.   Create a new catalog pg_db_role_setting where they are now stored, and better encapsulate the code ...

This post has been updated with new code that uses temporary table - the code is at the end of post! There was this question on Stack Overflow. For future reference: guy asked how to do session variables - i.e. something he ...

Also yesterday, and also Peter Eisentraut, committed patch by Guillaume Smet, which: Add log_line_prefix placeholder %e to contain the current SQL state   Author: Guillaume Smet