Re: Optimizer items in the release notes - Mailing list pgsql-hackers

From Adam Brusselback
Subject Re: Optimizer items in the release notes
Date
Msg-id CAMjNa7fgvsq+R1oDYw5hJVE_uhx=nWBydZT0P=Vzb1-aH+qyYw@mail.gmail.com
Whole thread Raw
In response to Re: Optimizer items in the release notes  (David Rowley <david.rowley@2ndquadrant.com>)
Responses Re: Optimizer items in the release notes
List pgsql-hackers
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.

pgsql-hackers by date:

Previous
From: Alexander Korotkov
Date:
Subject: Re: Regression test coverage of GiST index build is awful
Next
From: Alvaro Herrera
Date:
Subject: Re: pg_dump partitions can lead to inconsistent state after restore