complicated queries in pl/pgsql - Mailing list pgsql-performance

From Tomasz Myrta
Subject complicated queries in pl/pgsql
Date
Msg-id 3E23EC83.9060802@klaster.net
Whole thread Raw
Responses Re: complicated queries in pl/pgsql
Re: complicated queries in pl/pgsql
List pgsql-performance
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


pgsql-performance by date:

Previous
From: Ron Johnson
Date:
Subject: Re: Cursor rowcount
Next
From: CaptainX0r
Date:
Subject: Sun vs. Mac