Re: Release 14 Schedule

2021-09-25 Thread Tom Lane
Robert Haas writes: > Still, this kind of seems like a laundry list to me. I'd argue for > cutting range types, extended statistics, SEARCH / CYCLE, TOAST, and > emergency mode vacuum. They're all nice, and I'm glad we have them, > but they're also things that only people who are deeply steeped in

Re: Release 14 Schedule

2021-09-23 Thread Robert Haas
On Wed, Sep 22, 2021 at 12:00 PM Jonathan S. Katz wrote: > - Numerous performance ... > - B-tree... > - Subscripting ... > - Range types ... > - Stored ... > - Extended ... > - SEARCH / CYCLE ... > - libpq ... > - TOAST ... > (- emergency mode vacuum ...) My opinion is that this is awfully long f

Re: Release 14 Schedule

2021-09-23 Thread Magnus Hagander
On Wed, Sep 22, 2021 at 11:01 PM Tom Lane wrote: > > Magnus Hagander writes: > > On Wed, Sep 22, 2021 at 6:30 PM Tom Lane wrote: > >> I thought the point about FDWs was important because actual work (by > >> FDW authors) is needed to make anything happen. The extra parallelism > >> inside plpgs

Re: Release 14 Schedule

2021-09-22 Thread Jonathan S. Katz
On 9/22/21 10:43 PM, Peter Geoghegan wrote: > On Wed, Sep 22, 2021 at 7:06 PM Tom Lane wrote: >> Ummm ... RC1 was wrapped on Monday. It will go out with the "TO BE ADDED" >> placeholder for this list. I'm not panicked about time --- we just need >> to finalize this text by Sunday-ish. > > I ass

Re: Release 14 Schedule

2021-09-22 Thread Peter Geoghegan
On Wed, Sep 22, 2021 at 7:06 PM Tom Lane wrote: > Ummm ... RC1 was wrapped on Monday. It will go out with the "TO BE ADDED" > placeholder for this list. I'm not panicked about time --- we just need > to finalize this text by Sunday-ish. I assumed that the web team had the discretion to keep the

Re: Release 14 Schedule

2021-09-22 Thread Tom Lane
Peter Geoghegan writes: > On Wed, Sep 22, 2021 at 2:01 PM Tom Lane wrote: >> Certainly. But my sentence about "Numerous performance improvements" >> already mashes down dozens of other it-just-works-better-now >> performance improvements. Wny call out that one in particular? > RC 1 is supposed

Re: Release 14 Schedule

2021-09-22 Thread Peter Geoghegan
On Wed, Sep 22, 2021 at 2:01 PM Tom Lane wrote: > Certainly. But my sentence about "Numerous performance improvements" > already mashes down dozens of other it-just-works-better-now > performance improvements. Wny call out that one in particular? RC 1 is supposed to be released in less than 24

Re: Release 14 Schedule

2021-09-22 Thread Tom Lane
Magnus Hagander writes: > On Wed, Sep 22, 2021 at 6:30 PM Tom Lane wrote: >> I thought the point about FDWs was important because actual work (by >> FDW authors) is needed to make anything happen. The extra parallelism >> inside plpgsql functions doesn't require user effort, so I don't see >> th

Re: Release 14 Schedule

2021-09-22 Thread Magnus Hagander
On Wed, Sep 22, 2021 at 6:30 PM Tom Lane wrote: > > "Jonathan S. Katz" writes: > > On 9/22/21 11:15 AM, Magnus Hagander wrote: > >> On Wed, Sep 22, 2021 at 5:12 PM Tom Lane wrote: > >>> Numerous performance improvements have been made for parallel queries, > >>> heavily-concurrent workloads, par

Re: Release 14 Schedule

2021-09-22 Thread Jonathan S. Katz
On 9/22/21 12:30 PM, Tom Lane wrote: > "Jonathan S. Katz" writes: >> On 9/22/21 11:15 AM, Magnus Hagander wrote: >>> I have a feeling emergency mode vacuum fits on that list. Not in the >>> press release, but in the major features list of the release notes. > >> Given some recent news I saw floa

Re: Release 14 Schedule

2021-09-22 Thread Justin Pryzby
On Wed, Sep 22, 2021 at 12:00:07PM -0400, Jonathan S. Katz wrote: > On 9/22/21 11:15 AM, Magnus Hagander wrote: > > On Wed, Sep 22, 2021 at 5:12 PM Tom Lane wrote: > >> "Jonathan S. Katz" writes: > >>> On 9/19/21 12:32 PM, Justin Pryzby wrote: > On Sat, Sep 18, 2021 at 01:37:19PM -0400, Tom

Re: Release 14 Schedule

2021-09-22 Thread Tom Lane
"Jonathan S. Katz" writes: > On 9/22/21 11:15 AM, Magnus Hagander wrote: >> On Wed, Sep 22, 2021 at 5:12 PM Tom Lane wrote: >>> Numerous performance improvements have been made for parallel queries, >>> heavily-concurrent workloads, partitioned tables, logical replication, and >>> vacuuming. Not

Re: Release 14 Schedule

2021-09-22 Thread Jonathan S. Katz
On 9/22/21 11:15 AM, Magnus Hagander wrote: > On Wed, Sep 22, 2021 at 5:12 PM Tom Lane wrote: >> >> "Jonathan S. Katz" writes: >>> On 9/19/21 12:32 PM, Justin Pryzby wrote: On Sat, Sep 18, 2021 at 01:37:19PM -0400, Tom Lane wrote: > We don't yet have a list-of-major-features for the v14

Re: Release 14 Schedule

2021-09-22 Thread Pavel Luzanov
Hello, Stored procedures can now return data via OUT parameters. The SQL-standard SEARCH and CYCLE options for common table expressions have been implemented. I think that from the application developer point of view very important feature: * Allow SQL-language functions and procedures to us

Re: Release 14 Schedule

2021-09-22 Thread Magnus Hagander
On Wed, Sep 22, 2021 at 5:12 PM Tom Lane wrote: > > "Jonathan S. Katz" writes: > > On 9/19/21 12:32 PM, Justin Pryzby wrote: > >> On Sat, Sep 18, 2021 at 01:37:19PM -0400, Tom Lane wrote: > >>> We don't yet have a list-of-major-features for the v14 release notes. > >>> Anybody care to propose one

Re: Release 14 Schedule

2021-09-22 Thread Tom Lane
"Jonathan S. Katz" writes: > On 9/19/21 12:32 PM, Justin Pryzby wrote: >> On Sat, Sep 18, 2021 at 01:37:19PM -0400, Tom Lane wrote: >>> We don't yet have a list-of-major-features for the v14 release notes. >>> Anybody care to propose one? > I can try proposing some wording on this in a bit; I'm w

Re: Release 14 Schedule

2021-09-20 Thread Gavin Flower
On 21/09/21 14:23, Jonathan S. Katz wrote: On 9/20/21 2:33 AM, Nikolay Samokhvalov wrote: Observability-related improvements are also good and very important for the future of DBA operations -- compute_query_id, new pg_stat_**, etc. Things like new knob idle_session_timeout and restore_comman

Re: Release 14 Schedule

2021-09-20 Thread Jonathan S. Katz
On 9/20/21 2:33 AM, Nikolay Samokhvalov wrote: > Observability-related improvements are also good and very important for > the future of DBA operations -- compute_query_id, new pg_stat_**, etc. > > Things like new knob idle_session_timeout and restore_command change not > requiring a restart will

Re: Release 14 Schedule

2021-09-19 Thread Nikolay Samokhvalov
Observability-related improvements are also good and very important for the future of DBA operations -- compute_query_id, new pg_stat_**, etc. Things like new knob idle_session_timeout and restore_command change not requiring a restart will be very noticeable too. On Sun, Sep 19, 2021 at 2:45 PM

Re: Release 14 Schedule

2021-09-19 Thread Amit Kapila
On Mon, Sep 20, 2021 at 3:15 AM Jonathan S. Katz wrote: > > On 9/19/21 12:32 PM, Justin Pryzby wrote: > > On Sat, Sep 18, 2021 at 01:37:19PM -0400, Tom Lane wrote: > >> We don't yet have a list-of-major-features for the v14 release notes. > >> Anybody care to propose one? > > > > . Allow extende

Re: Release 14 Schedule

2021-09-19 Thread Jonathan S. Katz
On 9/19/21 12:32 PM, Justin Pryzby wrote: > On Sat, Sep 18, 2021 at 01:37:19PM -0400, Tom Lane wrote: >> We don't yet have a list-of-major-features for the v14 release notes. >> Anybody care to propose one? > > . Allow extended statistics on column expressions; > . Memoize node which can impro

Re: Release 14 Schedule

2021-09-19 Thread Justin Pryzby
On Sat, Sep 18, 2021 at 01:37:19PM -0400, Tom Lane wrote: > We don't yet have a list-of-major-features for the v14 release notes. > Anybody care to propose one? . Allow extended statistics on column expressions; . Memoize node which can improve speed of nested loop joins; . Allow use of LZ4

Re: Release 14 Schedule

2021-09-18 Thread Tom Lane
Andrew Dunstan writes: > The Release Management Team (Michael Paquier, Peter Geoghegan and > myself) in consultation with the release team proposes the following > release schedule: > * PostgreSQL 14 Release Candidate 1 (RC1) will be released on September 23, > 2021. > * In the absence of any cri

Re: Release 14 Schedule

2021-09-15 Thread Andrew Dunstan
On 9/15/21 10:20 AM, Robert Haas wrote: > On Wed, Sep 15, 2021 at 8:56 AM Andrew Dunstan wrote: >> The Release Management Team (Michael Paquier, Peter Geoghegan and >> myself) in consultation with the release team proposes the following >> release schedule: >> >> * PostgreSQL 14 Release Candidat

Re: Release 14 Schedule

2021-09-15 Thread Robert Haas
On Wed, Sep 15, 2021 at 8:56 AM Andrew Dunstan wrote: > The Release Management Team (Michael Paquier, Peter Geoghegan and > myself) in consultation with the release team proposes the following > release schedule: > > * PostgreSQL 14 Release Candidate 1 (RC1) will be released on September 23, > 20