Обсуждение: 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
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?
Best Regards,
Sameer Kumar | Database Consultant
ASHNIK PTE. LTD.
101 Cecil Street, #11-11 Tong Eng Building, Singapore 069533
M: +65 8110 0350 T: +65 6438 3504 | www.ashnik.com
This email may contain confidential, privileged or copyright material and is solely for the use of the intended recipient(s).
Вложения
I went through the wiki page (and I understand that it is WIP), I did not see Time Delayed Standby listed there:I believe 9.4 will introduce a new recovery.conf parameterrecovery_min_apply_delayAm I missing something or the feature has been postponed? Or someone has this on ToDo list [ :-) ] ?
Nope, this feature has been committed for 9.4:
commit 36da3cfb457b77a55582f68208d815f11ac1399e
Author: Simon Riggs <simon@2ndQuadrant.com>
Date: Thu Dec 12 10:53:20 2013 +0000
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 Simon Riggs
Detailed review by Mitsumasa Kondo
Michael
Nope, this feature has been committed for 9.4:
commit 36da3cfb457b77a55582f68208d815f11ac1399e
Author: Simon Riggs <simon@2ndQuadrant.com>
Date: Thu Dec 12 10:53:20 2013 +0000
The wiki page is simply not really complete...
Best Regards,
Sameer Kumar | Database Consultant
ASHNIK PTE. LTD.
101 Cecil Street, #11-11 Tong Eng Building, Singapore 069533
M: +65 8110 0350 T: +65 6438 3504 | www.ashnik.com
This email may contain confidential, privileged or copyright material and is solely for the use of the intended recipient(s).
Вложения
Gabriele Bartolini - 2ndQuadrant Italia
PostgreSQL Training, Services and Support
gabriele.bartolini@2ndQuadrant.it | www.2ndQuadrant.it
On Wed, May 28, 2014 at 2:49 PM, Michael Paquier <michael.paquier@gmail.com> wrote:Nope, this feature has been committed for 9.4:
commit 36da3cfb457b77a55582f68208d815f11ac1399e
Author: Simon Riggs <simon@2ndQuadrant.com>
Date: Thu Dec 12 10:53:20 2013 +0000Such a relief! I am really looking forward to this feature! :-)I found replication_slots useful too and I guess it will be more important given that we can have time-delayed standby (otherwise calculating wal_keep_segment could have been a real pain).The wiki page is simply not really complete...I would be happy to contribute in any possible way :-)Best Regards,
Sameer Kumar | Database Consultant
ASHNIK PTE. LTD.
101 Cecil Street, #11-11 Tong Eng Building, Singapore 069533
M: +65 8110 0350 T: +65 6438 3504 | www.ashnik.com
This email may contain confidential, privileged or copyright material and is solely for the use of the intended recipient(s).
Вложения
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