Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1u3Nqn-00Ey2g-BH for pgsql-general@arkaria.postgresql.org; Fri, 11 Apr 2025 23:31:57 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1u3Nqk-00FkHs-Va for pgsql-general@arkaria.postgresql.org; Fri, 11 Apr 2025 23:31:55 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1u3Nqk-00FkHj-HK for pgsql-general@lists.postgresql.org; Fri, 11 Apr 2025 23:31:54 +0000 Received: from mail-lf1-x129.google.com ([2a00:1450:4864:20::129]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.96) (envelope-from ) id 1u3Nqi-004p4g-1s for pgsql-general@lists.postgresql.org; Fri, 11 Apr 2025 23:31:54 +0000 Received: by mail-lf1-x129.google.com with SMTP id 2adb3069b0e04-54b166fa41bso2968580e87.0 for ; Fri, 11 Apr 2025 16:31:52 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20230601; t=1744414310; x=1745019110; darn=lists.postgresql.org; h=cc:to:subject:message-id:date:from:in-reply-to:references :mime-version:from:to:cc:subject:date:message-id:reply-to; bh=rU91AmtvegWhuPJ2NX3gMKC/kpEV9sp8mOiON2dawZw=; b=GALmRke6nSqhh16OaMGVX8hU6thHYlgo7+sV05DIChsYj92TL1IsFoY+vd0gS1wCJz E7GtZ7CzW/3vCz8u4vbrgWMSIKGQ1I9pVWE5sHxToBJbcwnfYR5wt/l+UMtrfFPgns3y mp2GwphfQKPt4OE+jqDblLsOT8UonWQP6ATXboEmEbpUANm7Kx5wADk44WtMerXHKUZF Drq2Ufn36QjB75VSeWu6Xba5zl/aAst8Q0engU9olezQZu/LEWZrdOlff30oosRBU815 ZE3oSYTGspuO/pwJ05JhGwsMKjDzyib3VzJApaqdZYD0M+3dX6rP5T2BJo0l9otEmgZ+ HlXw== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1744414310; x=1745019110; h=cc:to:subject:message-id:date:from:in-reply-to:references :mime-version:x-gm-message-state:from:to:cc:subject:date:message-id :reply-to; bh=rU91AmtvegWhuPJ2NX3gMKC/kpEV9sp8mOiON2dawZw=; b=la9QJNeOCY3HtVqbxgmDM2AvANXkUTQBUqfLUtUjhkUQapNkBHbJUUk5LoRis2CCah fQrtmqwVFbPI0blKbUsCDyCfcxl7IK9KTs4YA/eCeLzJkWgYQAB6kBNwV62jTlhK2SGX bE/2aUFpzlNxw9tHQVGSDDl64LjtZ9sMNdAmqJm482pNlWaR4Z0Yz7Rjzwkg9BRaC+cw c3EyKgIYBU3d8CyaGY6qRr1A6gf6/kFCu+qBduz0LV8xJ4dZE+u/n5jga4kvuCbQKWdg fugyOfLiR+szIV+A88mq9ENd0+LT+NyaAXLA3/fT6/zbpDd9Tyd6VNkoX0tY6JOwhuQa Ey4g== X-Forwarded-Encrypted: i=1; AJvYcCUsQeWo/4GUyhLgUEYVf7YBmeDKWJsRVdp9gTBoAU54Di/3d7yBvx62fWR34MsPuoyBKRWYOEVyJsDp2u77@lists.postgresql.org X-Gm-Message-State: AOJu0YyKfHvn1htMloN7AAdu2LNvx3f3oU2+AV9P4j3cw6AtxftJwEaW Yzu0hUfIIkqIx/8D5cCYEnUdUH1OqscVCyCJjkJ+/SKBIVow5HLXFF4RA+nOoQMUQRCdspZ4TfH Q2qFc27RF4H4oAKHq9NUc7oCi3sE= X-Gm-Gg: ASbGncv9VeiH8SVcexHu+jyUGMCzOqOOv2nh4318yczNt7R6KVDBpZKiLZTCo+yMaMd WXjRKgxxBTfndufCEo4aA4H24HUbHkCmqBXmLFmhf/8PengcxbNC8xzCZGyj4jWw5e6sGYVikCJ PIyWzKcyOuKfogw9ukE7nfMaskIs8FxctGa+GvPMz9ZILwg7UYDu4gpMI= X-Google-Smtp-Source: AGHT+IEUwgQnTUooG5PuqIyG4GXGAN6lF7I648yynJcL2+JYl63AstLKSaBtETUh2KXJ6k8k3cdhFq/yxSdmtvdvmZ8= X-Received: by 2002:a05:6512:114e:b0:549:38d2:f630 with SMTP id 2adb3069b0e04-54d45296b1cmr1467377e87.24.1744414310028; Fri, 11 Apr 2025 16:31:50 -0700 (PDT) MIME-Version: 1.0 References: <662101e2-5ca5-4bf5-9307-2519efde8690@ya.ru> <8687df7d49bc4b28b41c7cf4e9ad1e15d383b2fa.camel@cybertec.at> <752812.1744343513@sss.pgh.pa.us> In-Reply-To: <752812.1744343513@sss.pgh.pa.us> From: Merlin Moncure Date: Fri, 11 Apr 2025 18:31:35 -0500 X-Gm-Features: ATxdqUFqp6RvY9fBI8gUXyaNb3exfODxbYXt6aEhXBsIIcJxrS5GvkgHMIYMFVc Message-ID: Subject: Re: Interesting case of IMMUTABLE significantly hurting performance To: Tom Lane Cc: "David G. Johnston" , Nico Williams , Adrian Klaver , Laurenz Albe , Olleg Samoylov , "pgsql-generallists.postgresql.org" Content-Type: multipart/alternative; boundary="0000000000004a5d480632891b21" List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --0000000000004a5d480632891b21 Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable On Thu, Apr 10, 2025 at 10:51=E2=80=AFPM Tom Lane wrote= : > Merlin Moncure writes: > > I guess the real problems here are lack of feedback on a number of > fronts: > > *) the server knows the function is not immutable but lets you create i= t > > anyway, even though it can have negative downstream consequences > > That's debatable I think. If you know what you're doing, you're going > to be annoyed by warnings telling you that you don't. > > > *) there is no way to discern inline vs non-inlined execution in explai= n > > That's simply false. Using the examples in this thread: > ah -- gotcha. misread the original email -- should have known better :) thanks merlin --0000000000004a5d480632891b21 Content-Type: text/html; charset="UTF-8" Content-Transfer-Encoding: quoted-printable
On Thu, Apr 10, 2025 at = 10:51=E2=80=AFPM Tom Lane <tgl@sss.pgh.pa.us> wrote:
Merlin Moncure <mmoncure@gmail.com&= gt; writes:
> I guess the real problems here are lack of feedback on a number of fro= nts:
> *) the server knows the function is not immutable but lets you create = it
> anyway, even though it can have negative downstream consequences

That's debatable I think.=C2=A0 If you know what you're doing, you&= #39;re going
to be annoyed by warnings telling you that you don't.

> *) there is no way to discern inline vs non-inlined execution in expla= in

That's simply false.=C2=A0 Using the examples in this thread:

ah -- gotcha.=C2=A0 misread the original email -= -=C2=A0 should have known better :)=C2=A0
thanks=C2=A0
=
merlin
--0000000000004a5d480632891b21--