February 29th, 2016 by depesz | Tags: , , , , , | Comments Off on Waiting for 9.6 – Add new system view, pg_config

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

May 21st, 2015 by depesz | Tags: , , , , , , , | Comments Off on Waiting for 9.5 – Add pg_settings.pending_restart column

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

February 25th, 2015 by depesz | Tags: , , , , , , , , | Comments Off on Waiting for 9.5 – Replace checkpoint_segments with min_wal_size and max_wal_size.

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

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