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 1pmZ1f-0006Jx-08
	for pgsql-interfaces@arkaria.postgresql.org; Wed, 12 Apr 2023 11:52:35 +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 1pmZ1d-0008MH-S0
	for pgsql-interfaces@arkaria.postgresql.org; Wed, 12 Apr 2023 11:52:33 +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 <pgchem@tuschehund.de>)
	id 1pmYjW-0001b8-8W
	for pgsql-interfaces@lists.postgresql.org; Wed, 12 Apr 2023 11:33:50 +0000
Received: from mo4-p00-ob.smtp.rzone.de ([85.215.255.23])
	by magus.postgresql.org with esmtps  (TLS1.3) tls
 TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384
	(Exim 4.94.2)
	(envelope-from <pgchem@tuschehund.de>)
	id 1pmYjR-002Qnu-AI
	for pgsql-interfaces@postgresql.org; Wed, 12 Apr 2023 11:33:49 +0000
ARC-Seal: i=1; a=rsa-sha256; t=1681299223; cv=none;
    d=strato.com; s=strato-dkim-0002;
    b=DYAjNLxDNTeDjY8nIAgPKoEU6sdfvRszVlFSLGdult0Cz9ICl0IYyw7xrFQCVMKAfe
    YjC9uMaHFxjds4pCDgQAQ4PLyFNiMRP2rtAiXErueKGJE5xO3s9U1Ixn2P/gDdx6gtNb
    IKTZfWLIA+5ImILPeo1GhuqoTS1R1FcM1T9HKGisRAzVjqfnHwgAvo7Hyo+w1zKGowud
    pTiXXn/vcdRrt6SESwFcOjCGYcMG9Yd11nrtEcBnvMt71m11wd5w8GrX5TFt91SeOxOk
    Q05Qn2QnuP10E8f3E+vbTUYxBCAX2EKRt8Kfh4wCod7tvemei6xnJe7kHS1eKfSMUwaB
    JvKA==
ARC-Message-Signature: i=1; a=rsa-sha256; c=relaxed/relaxed; t=1681299223;
    s=strato-dkim-0002; d=strato.com;
    h=Subject:References:In-Reply-To:Message-ID:Cc:To:From:Date:Cc:Date:
    From:Subject:Sender;
    bh=hYUrcdIluTxB5aX9MJaL9AIJ0cnGGPDBfCBWtrh/kM8=;
    b=CqYxH6H2kUd+eRYDoYqryQknliNLDUEoJ9KaBfRnI1xZfNee4I6MNS5TJeDZ2BxYMM
    xQ+KlGeAYQv0aR4VBNzxgWWxEQS7Gnl6he3hOeU46cPNQsom2enq5aLDobXdVrjFm2XK
    g+UzYxEK2Z9+Hf4K0H8TCXjLSzE0NB01+jDhzRebKB1c1gI+li6l9B6lKFQkFo4j7Ndi
    PkTPuTtfDvBv4EwNsYf/Rpxh2eZjHCUXcvEJqxEu9j1ODL0phVq3w29scCvjWeNsAWT6
    RLM+/fxlTLwnN0MNKV6vaEx0WxMMxeY5rKHC6StZI9wvU4nNc7zF1ueVjPu0d07499EN
    OXRw==
ARC-Authentication-Results: i=1; strato.com;
    arc=none;
    dkim=none
X-RZG-CLASS-ID: mo00
DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; t=1681299223;
    s=strato-dkim-0002; d=tuschehund.de;
    h=Subject:References:In-Reply-To:Message-ID:Cc:To:From:Date:Cc:Date:
    From:Subject:Sender;
    bh=hYUrcdIluTxB5aX9MJaL9AIJ0cnGGPDBfCBWtrh/kM8=;
    b=W7lLIvwCcKlaghPn5mcNvc+q5IkNOC+JibAvNl+B/AWxHMbJwFEaPedw59FPHmqhyq
    TQcs0q13vIpodLtuf5BMKRhW4FGYcEST4bqhAVmt3uO6JBnlNlZ70Q9IMttN3j+XgzmB
    veP2VlTfXMKFbD/meHQaquPwf6McjJ7sdHZNk7/yaYObGRFVmKbYg9A88+2KNQj8qfQ7
    ymX4KSxNHup8NhiW0KLqxuNWxLTYGYiLBFcF7Vi4OKxUFcgTa++Nm6B0VbB/RcufOdx5
    fPGDtmIcCAgH0ViFtcBq8k7d45HHZK5pEYri39MNi61YxZD4OV3mZjrxY+JnSIhTD9rV
    lYUg==
DKIM-Signature: v=1; a=ed25519-sha256; c=relaxed/relaxed; t=1681299223;
    s=strato-dkim-0003; d=tuschehund.de;
    h=Subject:References:In-Reply-To:Message-ID:Cc:To:From:Date:Cc:Date:
    From:Subject:Sender;
    bh=hYUrcdIluTxB5aX9MJaL9AIJ0cnGGPDBfCBWtrh/kM8=;
    b=RX8tJX3BURkuApTlKbvkFe+nJqk8jspIDzbtW8uTO3hg7wO9Ziw14BI5R4iUU332fp
    t9j24hoX21VZ+Z0t/HCA==
X-RZG-AUTH: 
 ":PGsHfUWlW+tE6dGLopx2tLHUf2ZSPNp165/ViMXYddg/otfF87vGByLk0QyiSLBPLg3c"
Received: from ox-live-app101.back.ox.d0m.de
    by smtp-ox.front (RZmta 49.4.0 AUTH)
    with ESMTPSA id Y067e0z3CBXhkTq
	(using TLSv1.2 with cipher ECDHE-RSA-AES256-GCM-SHA384 (curve
 X9_62_prime256v1 with 256 ECDH bits, eq. 3072 bits RSA))
	(Client did not present a certificate);
    Wed, 12 Apr 2023 13:33:43 +0200 (CEST)
Date: Wed, 12 Apr 2023 13:33:42 +0200 (CEST)
From: pgchem pgchem <pgchem@tuschehund.de>
To: Dave Cramer <davecramer@postgres.rocks>
Cc: "pgsql-interfaces@postgresql.org" <pgsql-interfaces@postgresql.org>
Message-ID: <538907970.2383682.1681299222931@webmail.strato.de>
In-Reply-To: 
 <CADK3HHJ0HtYy=6ErV69v9Emj2VsEkpJwvvcE-Rx9n1sDAAGrfw@mail.gmail.com>
References: <607407366.2321178.1681284910101@webmail.strato.de>
 <CADK3HHJ0HtYy=6ErV69v9Emj2VsEkpJwvvcE-Rx9n1sDAAGrfw@mail.gmail.com>
Subject: Re: C trigger significantly slower than PL/pgSQL?
MIME-Version: 1.0
Content-Type: multipart/alternative;
	boundary="----=_Part_2383681_2034030953.1681299222930"
X-Priority: 3
Importance: Normal
X-Mailer: Open-Xchange Mailer v7.10.6-Rev40
X-Originating-Client: open-xchange-appsuite
Content-Transfer-Encoding: 7bit
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/538907970.2383682.1681299222931%40webmail.strato.de>
Precedence: bulk

------=_Part_2383681_2034030953.1681299222930
MIME-Version: 1.0
Content-Type: text/plain; charset=UTF-8
Content-Transfer-Encoding: 7bit

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.
 
best regards
 
Ernst-Georg

> 
> >  
> > 
> 

------=_Part_2383681_2034030953.1681299222930
MIME-Version: 1.0
Content-Type: text/html; charset=UTF-8
Content-Transfer-Encoding: 7bit

<!doctype html>
<html>
 <head> 
  <meta charset="UTF-8"> 
 </head>
 <body>
  <div>
   Hello Dave,
  </div> 
  <div class="default-style">
   &nbsp;
  </div> 
  <div class="default-style">
   &gt; It would be infinitely&nbsp;easier to answer this question if you posted both functions and the plans&nbsp;
  </div> 
  <div class="default-style">
   &nbsp;
  </div> 
  <div class="default-style">
   before posting lengthy code to the list, I just wanted to verify beforehand that this is not a well known issue.
  </div> 
  <div class="default-style">
   &nbsp;
  </div> 
  <div class="default-style">
   best regards
  </div> 
  <div class="default-style">
   &nbsp;
  </div> 
  <div class="default-style">
   Ernst-Georg
  </div> 
  <blockquote type="cite"> 
   <div dir="ltr"> 
    <div dir="ltr"> 
     <div class="gmail_quote"> 
      <blockquote> 
       <div> 
        <div>
         &nbsp;
        </div> 
       </div> 
      </blockquote> 
     </div> 
    </div> 
   </div> 
  </blockquote> 
 </body>
</html>
------=_Part_2383681_2034030953.1681299222930--