Re: Oracle to Postgres training at PGConf US
Date: Fri, 21 Jul 2017 18:53:05 -0400
Message-ID: <20170721185305.4ed30ec6.gogala.mladen_at_gmail.com>
On Fri, 21 Jul 2017 13:10:23 -0700
"Matthew Parker" <dimensional.dba_at_comcast.net> wrote:
> Actually if you go to the Merriam Webster's website you will find the game of Go under the noun section on the page for the word go.
>
> https://www.merriam-webster.com/dictionary/go
I thought we were talking about about what does it mean to be smart, not about the game of Go.
I am aware of the event and understood the reference. Thank you for stating the obvious.
>
> http://fortune.com/2016/03/12/googles-go-computer-vs-human/
>
> "Being Smart" in any interpretation of the phrase doesn't guarantee you will solve a problem in the most efficient or correct way. You can solve a problem for the moment and everyone is happy and you congratulate yourself as "being smart", but your solution fails a year later as some variable changes like size of the data 6 months down the road.
>
No, it doesn't mean that. However, it does mean that I need to have a possibility to influence the decision, if I consider it necessary. We were talking about performance hints. Performance hints are a method of overriding the decisions made by optimizer. You are the chief technologist of a remote DBA company. As such, I don't envision any circumstances in which you could have avoided using hints. What are you actually trying to say here? That you don't need hints for anything and that an optimizer, be it Oracle or Postgres, is smart enough that there is no need for an occasional override from humans? So, what do you do when a customer of yours comes to you and says "my SQL doesn't perform well"? Do you tell your customers that the hints are bad or do you use hints to make the performance improve, if you can? The whole thing started with hints, not with playing Go.
I don't understand your point. If you are trying to tell me that you don't like me, you chose the wrong topic.
-- Mladen Gogala Oracle DBA Tel: (347) 321-1217 -- http://www.freelists.org/webpage/oracle-lReceived on Sat Jul 22 2017 - 00:53:05 CEST