From: Heikki Linnakangas <heikki@enterprisedb.com>
To: Marcin Stępnicki <mstepnicki@gmail.com>
Cc: pgsql-performance@postgresql.org
Subject: Re: one column from huge view
Date: Thu, 12 Jul 2007 09:50:42 +0100
Message-ID: <4695EB62.7060307@enterprisedb.com> (raw)
In-Reply-To: <f74p19$1gb$1@sea.gmane.org>
References: <f74p19$1gb$1@sea.gmane.org>
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: heikki@enterprisedb.com, mstepnicki@gmail.com
Subject: Re: one column from huge view
In-Reply-To: <4695EB62.7060307@enterprisedb.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox