Re: complicated queries in pl/pgsql

From: Josh Berkus <josh(at)agliodbs(dot)com>
To: Tomasz Myrta <jasiek(at)klaster(dot)net>, PgSQL Performance ML <pgsql-performance(at)postgresql(dot)org>
Subject: Re: complicated queries in pl/pgsql
Date: 2003-01-13 18:44:50
Message-ID: 200301131044.50424.josh@agliodbs.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

Tomasz,

> What happens to view planning - is it performed
> during view creation, or rather each time view is quered?

Each time the view is executed. The only savings in running a view over a
regular query is that the view will have taken care of some reference
expansion and JOIN explication during the CREATE process, but not planning.
Also, views can actually be slower if the view is complex enough that any
query-time parameters cannot be "pushed down" into the view.

--
-Josh Berkus
Aglio Database Solutions
San Francisco

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message Stephan Szabo 2003-01-13 18:46:10 Re: Accessing ANALYZE stats
Previous Message Josh Berkus 2003-01-13 18:42:01 Accessing ANALYZE stats