Re: Views and query planner

From: Michael Glaesemann <grzm(at)seespotcode(dot)net>
To: mario(dot)splivalo(at)mobart(dot)hr
Cc: pgsql-sql(at)postgresql(dot)org
Subject: Re: Views and query planner
Date: 2006-06-30 12:47:31
Message-ID: 2D1768EE-58E1-4260-A940-3ED78D560EAB@seespotcode.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Mario Splivalo 2006-06-30 13:23:42 Re: Views and query planner
Previous Message Mario Splivalo 2006-06-30 12:35:48 Views and query planner