C trigger significantly slower than PL/pgSQL?

From: pgchem pgchem <pgchem(at)tuschehund(dot)de>
To: "pgsql-interfaces(at)postgresql(dot)org" <pgsql-interfaces(at)postgresql(dot)org>
Subject: C trigger significantly slower than PL/pgSQL?
Date: 2023-04-12 07:35:10
Message-ID: 607407366.2321178.1681284910101@webmail.strato.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-interfaces

Hello all,

I have a functionally identical trigger function in PL/pgSQL and C. Now, that the C version is about 3x _slower_ (~1500 vs. ~4500 TPS in pgbench) than PL/pgSQL comes somewhat unexpected.

It can very well be, that I made a mistake on the C side, but before everything else, I'd like to ask if this may be expected behavior. Is it plausible that PL/pgSQL is so much faster than C when used in a trigger function?

best regards

Ernst-Georg

Responses

Browse pgsql-interfaces by date

  From Date Subject
Next Message Dave Cramer 2023-04-12 11:05:14 Re: C trigger significantly slower than PL/pgSQL?
Previous Message Flaris Feller 2023-03-06 23:33:45 Re: Transaction control in a C language function