Hi
Sometimes my pl/pgsql functions have pretty complicated queries inside -
most of their execution time takes postgresql query planning.
I was wondering if I should change these queries into views? Does it
speed up function execution? Pl/pgsql saves execution plan for
connection lifetime. What happens to view planning - is it performed
during view creation, or rather each time view is quered?
Regards,
Tomasz Myrta