Guido Niewerth <gniewe...@ocsgmbh.com> writes:
> As you can see there“s a huge runtime difference between the select query 
> used in the trigger function and the one run from the SQL editor.

contrib/auto_explain might be useful in seeing what's going on, in
particular it would tell us whether or not a different plan is being
used for the query inside the function.

                        regards, tom lane


-- 
Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-performance

Reply via email to