Re: Slow query in trigger function - Mailing list pgsql-performance

From Tom Lane
Subject Re: Slow query in trigger function
Date
Msg-id 24307.1446475505@sss.pgh.pa.us
Whole thread Raw
In response to Slow query in trigger function  (Guido Niewerth <gniewerth@ocsgmbh.com>)
List pgsql-performance
Guido Niewerth <gniewerth@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
runfrom 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


pgsql-performance by date:

Previous
From: Michael Paquier
Date:
Subject: Re: PostgreSQL limitation
Next
From: Guido Niewerth
Date:
Subject: Re: Slow query in trigger function