Guido Niewerth <gniewerth@xxxxxxxxxxx> 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@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance