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 <pgsql-interfaces-owner+archive@lists.postgresql.org>)
	id 1pmZCm-000798-6B
	for pgsql-interfaces@arkaria.postgresql.org; Wed, 12 Apr 2023 12:04:04 +0000
Received: from localhost ([127.0.0.1] helo=malur.postgresql.org)
	by malur.postgresql.org with esmtp (Exim 4.92)
	(envelope-from <pgsql-interfaces-owner+archive@lists.postgresql.org>)
	id 1pmZCl-00031h-4e
	for pgsql-interfaces@arkaria.postgresql.org; Wed, 12 Apr 2023 12:04:03 +0000
Received: from makus.postgresql.org ([2001:4800:3e1:1::229])
	by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256)
	(Exim 4.92)
	(envelope-from <davecramer@postgres.rocks>)
	id 1pmZCk-00031X-TT
	for pgsql-interfaces@lists.postgresql.org; Wed, 12 Apr 2023 12:04:02 +0000
Received: from pgintl.fastcrypt.com ([149.56.129.164])
	by makus.postgresql.org with esmtp (Exim 4.92)
	(envelope-from <davecramer@postgres.rocks>)
	id 1pmZCi-0008PW-RY
	for pgsql-interfaces@postgresql.org; Wed, 12 Apr 2023 12:04:01 +0000
Received: from mail-ej1-f45.google.com (mail-ej1-f45.google.com
 [209.85.218.45])
	by pgintl.fastcrypt.com (Postfix) with ESMTPSA id A4C1D201AB
	for <pgsql-interfaces@postgresql.org>; Wed, 12 Apr 2023 08:03:59 -0400 (EDT)
Received: by mail-ej1-f45.google.com with SMTP id qa44so27857996ejc.4
        for <pgsql-interfaces@postgresql.org>;
 Wed, 12 Apr 2023 05:03:59 -0700 (PDT)
X-Gm-Message-State: AAQBX9eiXduAIQmbpHhjJBhGdFMlZx/Pz34SRRH+5GOrm6Cm6EAZidAd
	I6c8JzinHNmnKjHuQzLOGH8toq5w2aYr6STX6j8=
X-Google-Smtp-Source: 
 AKy350b4kNmAzSmYO8YCg3vtjK8DlMa6jF62fNHAQv3fIGlK0r+bHuxZTbBfFZSxbaLWIKirKm4qtznQz37ci3mCxEg=
X-Received: by 2002:a17:906:5913:b0:931:fb3c:f88d with SMTP id
 h19-20020a170906591300b00931fb3cf88dmr1116809ejq.5.1681301038421; Wed, 12 Apr
 2023 05:03:58 -0700 (PDT)
MIME-Version: 1.0
References: <607407366.2321178.1681284910101@webmail.strato.de>
 <CADK3HHJ0HtYy=6ErV69v9Emj2VsEkpJwvvcE-Rx9n1sDAAGrfw@mail.gmail.com>
 <538907970.2383682.1681299222931@webmail.strato.de>
In-Reply-To: <538907970.2383682.1681299222931@webmail.strato.de>
From: Dave Cramer <davecramer@postgres.rocks>
Date: Wed, 12 Apr 2023 08:03:41 -0400
X-Gmail-Original-Message-ID: 
 <CADK3HH+_Vi4uoRaQmDSNPoZfAvm8A_NLQ87=EaXv1DxxXYrmsQ@mail.gmail.com>
Message-ID: 
 <CADK3HH+_Vi4uoRaQmDSNPoZfAvm8A_NLQ87=EaXv1DxxXYrmsQ@mail.gmail.com>
Subject: Re: C trigger significantly slower than PL/pgSQL?
To: pgchem pgchem <pgchem@tuschehund.de>
Cc: "pgsql-interfaces@postgresql.org" <pgsql-interfaces@postgresql.org>
Content-Type: multipart/alternative; boundary="00000000000027dfe705f92267a4"
List-Id: <pgsql-interfaces.lists.postgresql.org>
List-Help: <https://lists.postgresql.org/manage/>
List-Subscribe: <https://lists.postgresql.org/manage/>
List-Post: <mailto:pgsql-interfaces@lists.postgresql.org>
List-Owner: <mailto:pgsql-interfaces-owner@lists.postgresql.org>
List-Archive: <https://www.postgresql.org/list/pgsql-interfaces>
Archived-At: 
 <https://www.postgresql.org/message-id/CADK3HH%2B_Vi4uoRaQmDSNPoZfAvm8A_NLQ87%3DEaXv1DxxXYrmsQ%40mail.gmail.com>
Precedence: bulk

--00000000000027dfe705f92267a4
Content-Type: text/plain; charset="UTF-8"

On Wed, 12 Apr 2023 at 07:33, pgchem pgchem <pgchem@tuschehund.de> wrote:

> Hello Dave,
>
> > It would be infinitely easier to answer this question if you posted both
> functions and the plans
>
> before posting lengthy code to the list, I just wanted to verify
> beforehand that this is not a well known issue.
>
Fair. So to answer your question. The C function should be faster.


Dave Cramer
www.postgres.rocks

--00000000000027dfe705f92267a4
Content-Type: text/html; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

<div dir=3D"ltr"><div dir=3D"ltr"><div dir=3D"ltr"><br></div><br><div class=
=3D"gmail_quote"><div dir=3D"ltr" class=3D"gmail_attr">On Wed, 12 Apr 2023 =
at 07:33, pgchem pgchem &lt;<a href=3D"mailto:pgchem@tuschehund.de">pgchem@=
tuschehund.de</a>&gt; wrote:<br></div><blockquote class=3D"gmail_quote" sty=
le=3D"margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);paddi=
ng-left:1ex"><u></u>

 =20
  =20
=20
 <div>
  <div>
   Hello Dave,
  </div>=20
  <div>
   =C2=A0
  </div>=20
  <div>
   &gt; It would be infinitely=C2=A0easier to answer this question if you p=
osted both functions and the plans=C2=A0
  </div>=20
  <div>
   =C2=A0
  </div>=20
  <div>
   before posting lengthy code to the list, I just wanted to verify beforeh=
and that this is not a well known issue.
  </div>=20
  <div>
   </div></div></blockquote><div>Fair. So to answer your question. The C fu=
nction should be faster.</div><div><br></div><div><br class=3D"gmail-Apple-=
interchange-newline">Dave Cramer<div>www.postgres.rocks</div></div><div><br=
></div><blockquote class=3D"gmail_quote" style=3D"margin:0px 0px 0px 0.8ex;=
border-left:1px solid rgb(204,204,204);padding-left:1ex"><div><blockquote t=
ype=3D"cite"><div dir=3D"ltr"><div dir=3D"ltr"><div class=3D"gmail_quote"><=
blockquote><div>=20
       </div>=20
      </blockquote>=20
     </div>=20
    </div>=20
   </div>=20
  </blockquote>=20
 </div>
</blockquote></div></div></div>

--00000000000027dfe705f92267a4--