| 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
| 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 |