From: | Gabriele Bartolini <gabriele(dot)bartolini(at)2ndquadrant(dot)it> |
---|---|
To: | Ian Barwick <ian(at)2ndquadrant(dot)com> |
Cc: | Josh Berkus <josh(at)agliodbs(dot)com>, PostgreSQL Advocacy <pgsql-advocacy(at)postgresql(dot)org> |
Subject: | Re: Need a "What's New in 9.4 Wiki Page" |
Date: | 2014-05-07 07:13:11 |
Message-ID: | CAHNtfO4=TeYk-3sxiJExdwAXnTsUFN++DjRuUUTvN2N0cy19kg@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | 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(dot)bartolini(at)2ndQuadrant(dot)it | www.2ndQuadrant.it
2014-05-07 8:14 GMT+02:00 Ian Barwick <ian(at)2ndquadrant(dot)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(at)postgresql(dot)org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-advocacy
From | Date | Subject | |
---|---|---|---|
Next Message | Gabriele Bartolini | 2014-05-07 13:13:35 | Re: Contest: Theme, Slogan for 9.4 |
Previous Message | Ian Barwick | 2014-05-07 06:14:25 | Re: Need a "What's New in 9.4 Wiki Page" |