Re: Need a "What's New in 9.4 Wiki Page" - Mailing list pgsql-advocacy
From | Gabriele Bartolini |
---|---|
Subject | Re: Need a "What's New in 9.4 Wiki Page" |
Date | |
Msg-id | CAHNtfO4=TeYk-3sxiJExdwAXnTsUFN++DjRuUUTvN2N0cy19kg@mail.gmail.com Whole thread Raw |
In response to | Re: Need a "What's New in 9.4 Wiki Page" (Ian Barwick <ian@2ndquadrant.com>) |
Responses |
Re: Need a "What's New in 9.4 Wiki Page"
Re: Need a "What's New in 9.4 Wiki Page" |
List | pgsql-advocacy |
Hi guys, as devops practitioner, I have been trying to classify the new features in two categories, Devs and Ops (which most of them falling in both worlds, I am just picking up the predominant category). Let me know if you like it. I can definitely work on the wiki. Here is a possible draft (I am using the commit title, every item should be rephrased). Devs * Improvements to JSON (jsonb, new json functions) * REFRESH MATERIALIZED VIEW CONCURRENTLY * ALTER TABLE ... ALTER CONSTRAINT for FKs * WITH CHECK OPTION support for auto-updatable VIEWs * Support multi-argument UNNEST(), and TABLE() syntax for multiple functions * Support ordered-set (WITHIN GROUP) aggregates * Add SQL Standard WITH ORDINALITY support for UNNEST (and any other SRF) * Implement the FILTER clause for aggregate function calls * Provide moving-aggregate support for a bunch of numerical aggregates * Include planning time in EXPLAIN ANALYZE output * Improve EXPLAIN to print the grouping columns in Agg and Group nodes * Constructors for interval, timestamp, timestamptz * psql: Make \pset without arguments show all settings * Add tab completion for \pset in psql * Add support for wrapping to psql's "extended" mode * PL/Perl: Add event trigger support Ops * Introduce replication slots * Logical decoding ** Add new wal_level, logical, sufficient for logical decoding. ** Introduce logical decoding. * pg_prewarm, a contrib module for prewarming relationd data. * Add CREATE TABLESPACE ... WITH ... Options * Add ALTER TABLESPACE ... MOVE command * Add pg_stat_archiver statistics view. * pg_basebackup: Add support for relocating tablespaces * Allow BASE_BACKUP to be throttled * Add recovery_target='immediate' option * Allow time delayed standbys and recovery * Add ALTER SYSTEM command to edit the server configuration file * auto_explain: Add logging of trigger execution Any thoughts? Ciao, Gabriele -- Gabriele Bartolini - 2ndQuadrant Italia PostgreSQL Training, Services and Support gabriele.bartolini@2ndQuadrant.it | www.2ndQuadrant.it 2014-05-07 8:14 GMT+02:00 Ian Barwick <ian@2ndquadrant.com>: > On 14/05/07 10:00, Josh Berkus wrote: >> ... someone wanna do the honors? Including linking some of the blog >> articles which have already gone up? > > You mean like this one? > > https://wiki.postgresql.org/wiki/What%27s_new_in_PostgreSQL_9.4 > > On vacation right now, but filling it out is on my to-do list. > > > -- > Ian Barwick http://www.2ndQuadrant.com/ > PostgreSQL Development, 24x7 Support, Training & Services > > > -- > Sent via pgsql-advocacy mailing list (pgsql-advocacy@postgresql.org) > To make changes to your subscription: > http://www.postgresql.org/mailpref/pgsql-advocacy
pgsql-advocacy by date: