On 28th of January, Andrew Dunstan committed patch: New json functions. json_build_array() and json_build_object allow for the construction of arbitrarily complex json trees. json_object() turns a one or two dimensional array, or two separate arrays, into a json_object of name/value pairs, similarly to the hstore() function. json_object_agg() aggregates its two arguments into a single … Continue reading “Waiting for 9.4 – New json functions.”
On 28th of January, Fujii Masao committed patch: Add pg_stat_archiver statistics view. This view shows the statistics about the WAL archiver process’s activity. Gabriele Bartolini, reviewed by Michael Paquier, refactored a bit by me.
On 25th of January, Heikki Linnakangas committed patch: Add recovery_target=’immediate’ option. This allows ending recovery as a consistent state has been reached. Without this, there was no easy way to e.g restore an online backup, without replaying any extra WAL after the backup ended. MauMau and me.
On 18th of January, Stephen Frost committed patch: Add ALTER TABLESPACE … MOVE command This adds a ‘MOVE’ sub-command to ALTER TABLESPACE which allows moving sets of objects from one tablespace to another. This can be extremely handy and avoids a lot of error-prone scripting. ALTER TABLESPACE … MOVE will only move objects the … Continue reading “Waiting for 9.4 – Tablespace changes”
On 23rd of December, Tom Lane committed patch: Support ordered-set (WITHIN GROUP) aggregates. This patch introduces generic support for ordered-set and hypothetical-set aggregate functions, as well as implementations of the instances defined in SQL:2008 (percentile_cont(), percentile_disc(), rank(), dense_rank(), percent_rank(), cume_dist()). We also added mode() though it is not in the spec, as well as … Continue reading “Waiting for 9.4 – Support ordered-set (WITHIN GROUP) aggregates.”
On 20th of December, Robert Haas committed patch: pg_prewarm, a contrib module for prewarming relationd data. Patch by me. Review by Álvaro Herrera, Amit Kapila, Jeff Janes, Gurjeet Singh, and others.
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 patch: Add tab completion for ALTER SYSTEM SET in psql.
On 12th of December, Simon Riggs committed patch: Allow time delayed standbys and recovery Set min_recovery_apply_delay to force a delay in recovery apply for commit and restore point WAL records. Other records are replayed immediately. Delay is measured between WAL record time and local standby time. Robert Haas, Fabrízio de Royes Mello and … Continue reading “Waiting for 9.4 – Allow time delayed standbys and recovery”
On 12th of December, Tom Lane committed patch: Improve EXPLAIN to print the grouping columns in Agg and Group nodes. Per request from Kevin Grittner.
On 11th of December, Peter Eisentraut committed patch: PL/Perl: Add event trigger support From: Dimitri Fontaine <dimitri@2ndQuadrant.fr>