DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=beta;
	h=received:message-id:date:from:user-agent:mime-version:to:cc:subject:references:in-reply-to:content-type:content-transfer-encoding:sender;
	b=jB+DYERpbZQCd1OQjLpAP+Z+gesW9/3Jx8UVQI8QIpq+xFmmSyCD6eG4qIKGp0AfzLu0Yx6d1O9IRzZL+7Eb5AnfCpssar5My65P7HaNcv0NB6NFk+c7iUhJhbIKAWntJT0IdE1BWXOpnjueEjw2fpBx/Y0x6QQOH7b53ansYoI=
Message-ID: <4695EB62.7060307@enterprisedb.com>
Date: Thu, 12 Jul 2007 09:50:42 +0100
From: Heikki Linnakangas <heikki@enterprisedb.com>
User-Agent: Icedove 1.5.0.10 (X11/20070329)
MIME-Version: 1.0
To: =?UTF-8?B?TWFyY2luIFN0xJlwbmlja2k=?= <mstepnicki@gmail.com>
CC: pgsql-performance@postgresql.org
Subject: Re: one column from huge view
References: <f74p19$1gb$1@sea.gmane.org>
In-Reply-To: <f74p19$1gb$1@sea.gmane.org>
Content-Type: text/plain; charset=UTF-8; format=flowed
Content-Transfer-Encoding: 8bit

Marcin Stępnicki wrote:
> Hello.
> 
> I've googled a bit but I think I can't match the keywords, so I thought
> I'll ask here:
> 
> Let's say I've got a view with 100 columns and 1mln rows; some of them are
> calculated "on the fly". For some reason I want only one column from
> this view:
> 
> select col1 from huge_view;
> 
> Now, does PostgreSQL skip all the calculations from other columns and
> executes this query faster then select * from huge_view?

In simple cases, yes. But for example, if you have a LEFT OUTER JOIN in 
the view, the join is performed even if your query doesn't return any 
columns from the outer relation. Also, if the calculation contains 
immutable functions, it's not skipped.

-- 
   Heikki Linnakangas
   EnterpriseDB   http://www.enterprisedb.com