Hi all,
I have been trying to improve the performance of a C trigger only to notice
that the real bottleneck was the SPI execution of dynamic SQL statements. I
had been using SPI_exec(sql,0) until I tried SPI_exec(sql,1), since I am
targeting exactly one row each time for writing. This simple change has made
a huge difference (2s --> 60ms in some cases), now the trigger execution
time is consistent with the response times I get if I run the same SQL
statements by hand in psql. I am happy my code performs better, but is this
something you would expect?
regards, Michael