Re: Optimizer items in the release notes

2019-04-27 Thread Bruce Momjian
On Sat, Apr 27, 2019 at 02:47:44PM +1200, David Rowley wrote: > On Sat, 27 Apr 2019 at 14:22, Bruce Momjian wrote: > > > > * They are hard to explain > > > > > > That can be true, but we generally get there if not the first time > > > then after a few iterations. Authors and committers of the > >

Re: Optimizer items in the release notes

2019-04-26 Thread David Rowley
On Sat, 27 Apr 2019 at 14:22, Bruce Momjian wrote: > > > * They are hard to explain > > > > That can be true, but we generally get there if not the first time > > then after a few iterations. Authors and committers of the > > improvements are likely to be able to help find suitable wording. > > I

Re: Optimizer items in the release notes

2019-04-26 Thread Bruce Momjian
> 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

Re: Optimizer items in the release notes

2019-04-26 Thread David Rowley
t; > 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 highlight

Re: Optimizer items in the release notes

2019-04-26 Thread Bruce Momjian
resent 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 * Th

Re: Optimizer items in the release notes

2019-04-24 Thread Adam Brusselback
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

Re: Optimizer items in the release notes

2019-04-24 Thread David Rowley
On Tue, 23 Apr 2019 at 04:54, Bruce Momjian wrote: > > We had a discussion in October about adding more optimizer items to the > release notes: > > > https://www.postgresql.org/message-id/flat/20181010220601.GA7807%40momjian.us#11d805ea0b0fcd0552dfa99251417cc1 > > There was no agreement o

Re: Optimizer items in the release notes

2019-04-24 Thread Adrien NAYRAT
On 4/22/19 6:54 PM, Bruce Momjian wrote: We had a discussion in October about adding more optimizer items to the release notes: https://www.postgresql.org/message-id/flat/20181010220601.GA7807%40momjian.us#11d805ea0b0fcd0552dfa99251417cc1 There was no agreement on a change, but if peop

Optimizer items in the release notes

2019-04-22 Thread Bruce Momjian
We had a discussion in October about adding more optimizer items to the release notes: https://www.postgresql.org/message-id/flat/20181010220601.GA7807%40momjian.us#11d805ea0b0fcd0552dfa99251417cc1 There was no agreement on a change, but if people want to propose a change, please post he