On Wed, Apr 24, 2019 at 02:46:15PM -0400, Adam Brusselback wrote:
> As a user, I am interested in the optimizer changes for sure, and I
> actually had wished they were highlighted more in previous releases.
>
> > I think planner smarts are arguably one of our weakest areas when
> > compared to the big commercial databases. The more we can throw in
> > there about this sort of thing the better.
>
> Completely agree on both fronts. I have run into numerous
> optimizations I had taken for granted when I worked primarily with SQL
> Server and were not present in Postgres. Work being done to make the
> Postgres optimizer smarter is great, as is highlighting that work in
> the release notes IMO.
This thread highlights the challenges of having optimizer items in the
release notes:
* They often reply to only a small percentage of queries
* They are hard to explain
I see the argument as wanting vague warm and fuzzy feelings that we are
improving the optimizer, which we are. I will see what I can do to get
those ideas into the PG 12 release notes in as concrete a way as
possible.
--
Bruce Momjian <bruce@momjian.us> http://momjian.us
EnterpriseDB http://enterprisedb.com
+ As you are, so once was I. As I am, so you will be. +
+ Ancient Roman grave inscription +