On 03/14/2013 03:22 PM, Artur Zając wrote:
>
> Why speed of executing (or planning) some very simple query from
> string in pl/pgsql is dependent from whole query or why “FOR r IN
> EXECUTE q” is significally slower from “FOR r IN query”?
>
>
The whole point of EXECUTE is that it's reparsed and planned each time.
You should expect it to be quite a bit slower, and avoid using EXECUTE
wherever possible.
cheers
andrew