Re: Views and query planner - Mailing list pgsql-sql

From Michael Glaesemann
Subject Re: Views and query planner
Date
Msg-id 2D1768EE-58E1-4260-A940-3ED78D560EAB@seespotcode.net
Whole thread Raw
In response to Views and query planner  (Mario Splivalo <mario.splivalo@mobart.hr>)
Responses Re: Views and query planner
List pgsql-sql
On Jun 30, 2006, at 21:35 , Mario Splivalo wrote:

> Is postgres going to make one query plan, or each view has it own  
> query
> plan?

Have you taken a look at the EXPLAIN ANALYZE output of the queries?  
You can see exactly which plan PostgreSQL will use.

Michael Glaesemann
grzm seespotcode net





pgsql-sql by date:

Previous
From: Mario Splivalo
Date:
Subject: Views and query planner
Next
From: Mario Splivalo
Date:
Subject: Re: Views and query planner