X-Original-To: pgsql-sql-postgresql.org@postgresql.org Received: from localhost (mx1.hub.org [200.46.208.251]) by postgresql.org (Postfix) with ESMTP id CD4289FA4A7 for ; Fri, 30 Jun 2006 09:47:45 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.208.251]) (amavisd-new, port 10024) with ESMTP id 62090-06 for ; Fri, 30 Jun 2006 09:47:44 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey- Received: from grzm.com (grzm.com [200.46.204.98]) by postgresql.org (Postfix) with ESMTP id 651569FA163 for ; Fri, 30 Jun 2006 09:47:44 -0300 (ADT) Received: from localhost (unknown [200.46.208.251]) by grzm.com (Postfix) with ESMTP id 05033127C4EF for ; Fri, 30 Jun 2006 13:47:39 +0100 (BST) Received: from grzm.com ([200.46.204.98]) by localhost (mx1.hub.org [200.46.208.251]) (amavisd-new, port 10024) with ESMTP id 73622-06; Fri, 30 Jun 2006 09:47:35 -0300 (ADT) Received: from [172.16.1.101] (unknown [61.197.227.146]) by grzm.com (Postfix) with ESMTP id 064FD127C4EC; Fri, 30 Jun 2006 13:47:29 +0100 (BST) In-Reply-To: <1151670948.27032.5.camel@localhost.localdomain> References: <1151670948.27032.5.camel@localhost.localdomain> Mime-Version: 1.0 (Apple Message framework v752.2) Content-Type: text/plain; charset=US-ASCII; delsp=yes; format=flowed Message-Id: <2D1768EE-58E1-4260-A940-3ED78D560EAB@seespotcode.net> Cc: pgsql-sql@postgresql.org Content-Transfer-Encoding: 7bit From: Michael Glaesemann Subject: Re: Views and query planner Date: Fri, 30 Jun 2006 21:47:31 +0900 To: mario.splivalo@mobart.hr X-Mailer: Apple Mail (2.752.2) X-Virus-Scanned: Maia Mailguard 1.0.1 X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200606/332 X-Sequence-Number: 25568 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