Thread: Need a "What's New in 9.4 Wiki Page"

... someone wanna do the honors?  Including linking some of the blog
articles which have already gone up?

--
Josh Berkus
PostgreSQL Experts Inc.
http://pgexperts.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

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

On 05/07/2014 12:13 AM, Gabriele Bartolini wrote:
> 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).
>

I think it would be cool to have those at the top of the page.

Hmmm, that also suggests a slogan ... "A Database for Both Dev and Ops"


--
Josh Berkus
PostgreSQL Experts Inc.
http://pgexperts.com

On 2014-05-07, 12:13 AM, Gabriele Bartolini wrote:
>    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).

I quite like this organization, actually, grouping together stuff more likely to
be of interest to particular kinds of users. -- Darren Duncan

On 05/28/2014 01:04 AM, Gabriele Bartolini wrote:
> Is it ok if I start organising the way I proposed it last month? (devs and
> ops)?

Well, since we're going for "Performance, Reliability, Flexibility" as
the theme, I'm kind of thinking we should organize it that way.  Of
course, that's not exclusive; pretty much Performance + Reliability is
Ops, and Flexibility is Dev.

--
Josh Berkus
PostgreSQL Experts Inc.
http://pgexperts.com

>
> On 05/28/2014 01:04 AM, Gabriele Bartolini wrote:
>> Is it ok if I start organising the way I proposed it last month? (devs
>> and
>> ops)?
>
> Well, since we're going for "Performance, Reliability, Flexibility" as
> the theme, I'm kind of thinking we should organize it that way.  Of
> course, that's not exclusive; pretty much Performance + Reliability is
> Ops, and Flexibility is Dev.

For me yes, I see it as being able to use non-sql and sql.




Saludos,
Gilberto Castillo
La Habana, Cuba
---
This message was processed by Kaspersky Mail Gateway 5.6.28/RELEASE running at host imx3.etecsa.cu
Visit our web-site: <http://www.kaspersky.com>, <http://www.viruslist.com>

On 05/28/2014 01:02 AM, Sameer Kumar wrote:
>> The wiki page is simply not really complete...
>>
>
> ​I would be happy to contribute in any possible way :-)

Please go ahead ... just start adding stuff to the wiki page.

--
Josh Berkus
PostgreSQL Experts Inc.
http://pgexperts.com