Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1mXapQ-0002yt-Ll for pgsql-performance@arkaria.postgresql.org; Tue, 05 Oct 2021 03:09:16 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1mXapP-0008Ds-JZ for pgsql-performance@arkaria.postgresql.org; Tue, 05 Oct 2021 03:09:15 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1mXapP-0008Dj-7H for pgsql-performance@lists.postgresql.org; Tue, 05 Oct 2021 03:09:15 +0000 Received: from mail-ed1-x532.google.com ([2a00:1450:4864:20::532]) by magus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_128_GCM_SHA256:128) (Exim 4.92) (envelope-from ) id 1mXapN-00063a-2j for pgsql-performance@lists.postgresql.org; Tue, 05 Oct 2021 03:09:14 +0000 Received: by mail-ed1-x532.google.com with SMTP id dj4so73153914edb.5 for ; Mon, 04 Oct 2021 20:09:12 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=bowt-ie.20210112.gappssmtp.com; s=20210112; h=mime-version:references:in-reply-to:from:date:message-id:subject:to :cc; bh=1dsN7Oz+YkxgbYlVSnxWarc596BTmA5BCYGOgusVYEI=; b=5lz5gZLoLKS7qBqVh/Ww6yjaSl5Gsy4h5wE09jIYn6iuoE85Y0kYYFjewQc9vqHtEL qnDKdZiTy77Ndf/QWGmLi0qNRfWziDlRrbW7kMdLZbAY6UlFpvBpocjxUcxP46uJraya J1F8/tjL+bih7vvMaA3zeIdw9JjBkWYJ61dKE/DehEwnKxS8dxdR42fNGlCDfaLyYF0D Pbs2+txsFY9PuCRudqNfVyIBD8HAVmfdlvB3dAvXKleGUGQIe1WZQfhUS5DmNe2tanbp 49tQySpk/DUy8okYXkibeK5tUDGe9UVodd94lD7qAvJt11RbbLoaWuflDr2rgsRN6gpR sVxQ== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20210112; h=x-gm-message-state:mime-version:references:in-reply-to:from:date :message-id:subject:to:cc; bh=1dsN7Oz+YkxgbYlVSnxWarc596BTmA5BCYGOgusVYEI=; b=2cmh+S10qvRqgYdKNbBjFJDCZGF1CVPtOTrLWlRC8d8tlvLk/21qgdC0C01QnMJVP/ i3s7sf/qJSgIYlTjk4IVBBMHXM42CSI0t40IqZqWcbKt3L1wmEwlKYuW9u/ZX/hYM+fl 7UIiueOucEfpnPU3U+JCukK1z9N9FcIE2P45oH13c46w45niULsHBrjinlqK69+vBI2z r2u+LPyWVva68dVAgkyv1pEUafHAV79qonXCcGz5C+h/6HkOFHG51TFxalNy2i7PQ0RP +VLyUo1HOGi+/A0cfYsiT2m/kc9yizPWz9i568NOA48RezLev9Giy0eNayM5+PVUBeiP +0WQ== X-Gm-Message-State: AOAM533MeDYgY987A/zFlEwUxhSLefUt70U9grjT5s1L6RA85T5nlWmk h75/psD27RBa6H91/462+8D1HePUR9bYLE0YBQgzTQ== X-Google-Smtp-Source: ABdhPJwVcWRRQ8zI9e1Z2JmeiamZfzIgnyFiPq85IVuNfUpkW0Rkp8GHyHnzX+Js9kw6b4qyfan9ElJzZrxSM9m5oLA= X-Received: by 2002:a05:6402:6d5:: with SMTP id n21mr3785339edy.262.1633403352291; Mon, 04 Oct 2021 20:09:12 -0700 (PDT) MIME-Version: 1.0 References: <9cecae326e8d73ff9e01c000d738b6a52dc76076.camel@cybertec.at> In-Reply-To: From: Peter Geoghegan Date: Mon, 4 Oct 2021 20:08:56 -0700 Message-ID: Subject: Re: Better, consistent instrumentation for postgreSQL using a similar API as Oracle To: Mladen Gogala Cc: pgsql-performance@lists.postgresql.org Content-Type: text/plain; charset="UTF-8" List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk On Mon, Oct 4, 2021 at 6:51 PM Mladen Gogala wrote: > Haughty lectures about "Oracle has it" not being good enough could > hardly be more out of place here. To put it as politely as is possible > in this case, shut your pie hole. What Jeff is asking for is not > something that "Oracle has", it's something that customers want. That > was the case few years ago when I was asking for the optimizer hints. I > was castigated by the former pastry baker turned Postgres guru and my > reaction was simple: I threw Postgres out of the company that I was a > working for as the lead DBA. You see, customer is always right, whether > the database is open source or not. Needless to say, Postgres has > optimizer hints these days. It still has them in "we do not want" part > of the Wiki, which is hilarious. In all sincerity: Chill out. I don't think that this is worth getting into an argument over. I think that there is a good chance that you'd have had a much better experience if the conversation had been in person. Text has a way of losing a lot of important nuance. I have personally met and enjoyed talking to quite a few people that personally worked on Oracle, in various capacities -- the world of database internals experts is not huge. I find Tanel Poder very interesting, too -- never met the man, but we follow each other on Twitter. Oracle is a system that has some interesting properties in general (not just as a counterpoint to PostgreSQL), and I definitely respect it. Same with SQL Server. There are lots of smart and accomplished people in the world, including Jeff. I think that it's worth understanding these differences in perspective. There is likely to be merit in all of the specific points made by both Laurenze and Jeff. They may not be irreconcilable, or anything like it. -- Peter Geoghegan