Re: PostgreSQL 12: Feature Highlights

From: Peter Geoghegan <pg(at)bowt(dot)ie>
To: Michael Paquier <michael(at)paquier(dot)xyz>
Cc: Alvaro Herrera <alvherre(at)2ndquadrant(dot)com>, Bruce Momjian <bruce(at)momjian(dot)us>, Amit Langote <Langote_Amit_f8(at)lab(dot)ntt(dot)co(dot)jp>, David Rowley <david(dot)rowley(at)2ndquadrant(dot)com>, "Jonathan S(dot) Katz" <jkatz(at)postgresql(dot)org>, PostgreSQL Advocacy <pgsql-advocacy(at)lists(dot)postgresql(dot)org>
Subject: Re: PostgreSQL 12: Feature Highlights
Date: 2019-05-17 00:05:13
Message-ID: CAH2-WznHtAuCcRMrNcocKNy1vN4w4e88d2XCT1fMMFnzjd-KiA@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-advocacy pgsql-hackers

On Thu, May 16, 2019 at 4:52 PM Michael Paquier <michael(at)paquier(dot)xyz> wrote:
> +1. Another thing which may matter is that if some people do not see
> some improvements they were expecting then they can come back to pg13
> and help around with having these added. Things are never going to be
> perfect for all users, and it makes little sense to make it sound like
> things are actually perfect.

Speaking of imperfections: it is well known that most performance
enhancements have the potential to hurt certain workloads in order to
help others. Maybe that was explicitly considered to be a good
trade-off when the feature went in, and maybe that was the right
decision at the time, but more often it was something that was simply
overlooked. There is value in leaving information that helps users
discover where a problem may have been introduced -- they can tell us
about it, and we can fix it.

I myself sometimes look through the release notes in an effort to spot
something that might have had undesirable side-effects, especially in
areas of the code that I am less knowledgeable about, or have only a
vague recollection of. Sometimes that is a reasonable starting point.

--
Peter Geoghegan

In response to

Responses

Browse pgsql-advocacy by date

  From Date Subject
Next Message Bruce Momjian 2019-05-17 01:27:40 Re: PostgreSQL 12: Feature Highlights
Previous Message Michael Paquier 2019-05-16 23:52:50 Re: PostgreSQL 12: Feature Highlights

Browse pgsql-hackers by date

  From Date Subject
Next Message Thomas Munro 2019-05-17 00:26:23 Re: Avoiding hash join batch explosions with extreme skew and weird stats
Previous Message Michael Paquier 2019-05-16 23:52:50 Re: PostgreSQL 12: Feature Highlights