Re: Oracle to Postgres training at PGConf US
- From: Mladen Gogala <gogala.mladen@xxxxxxxxx>
- To: "Matthew Parker" <dimensional.dba@xxxxxxxxxxx>
- Date: Fri, 21 Jul 2017 18:53:05 -0400
On Fri, 21 Jul 2017 13:10:23 -0700
"Matthew Parker" <dimensional.dba@xxxxxxxxxxx> 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.
Daniel's reference to Go relates to the Game of go being the hardest Game for
AI to overcome, but was overcome last year by Google.
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
--
//www.freelists.org/webpage/oracle-l
Other related posts: