Re: Oracle DBA to PostgreSQL DBA?

On 12/19/2016 03:13 AM, Thomas Kellerer wrote:
> Postgres has no query hints
Actually that one is no longer true. I was very vocal in complaining about hints, but now they do have them. There is an open source extension called pg_hint_plan which implement Oracle style optimizer hints with Postgres:

https://osdn.net/projects/pghintplan
http://pghintplan.osdn.jp/pg_hint_plan.html

However, partitioning is still a joke, using technology similar to Oracle's partition views in Oracle 7i. There is no wait event interface, so manual tuning of Postgres applications is mostly a black art, sometimes requiring human sacrifices. There is also a Postgres version of statspack, called pg_statspack. For all intents and purposes, Postgres is a toy. That is a consequence of having an attitude like this:

http://it.toolbox.com/blogs/database-soup/why-postgresql-doesnt-have-query-hints-44121

Josh Berkus, the author of this comic piece, is a very influential member of the Postgres community. With Bruce Momjian he forms a duo that I nicknamed "Dumb & Dumber". With a community like that, there is no future in Postgres. I tried it, I learned it and I ran away from it, never regretting it. I was even a speaker at a Postgres event:

https://www.meetup.com/postgresql-3/messages/boards/thread/9965998/

So I know what am I talking about.

-- 
Mladen Gogala
Oracle DBA
http://mgogala.freehostia.com

--
http://www.freelists.org/webpage/oracle-l