Re: Oracle DBA to PostgreSQL DBA?

From: Mladen Gogala <>
Date: Mon, 19 Dec 2016 19:30:25 -0500
Message-ID: <>

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:

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:

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:

So I know what am I talking about.

Mladen Gogala
Oracle DBA

Received on Tue Dec 20 2016 - 01:30:25 CET

Original text of this message