Received: from localhost (maia-3.hub.org [200.46.204.184]) by postgresql.org (Postfix) with ESMTP id 98D759FB51A for ; Thu, 12 Jul 2007 05:40:15 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.184]) (amavisd-maia, port 10024) with ESMTP id 94156-10 for ; Thu, 12 Jul 2007 05:40:04 -0300 (ADT) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.5 Received: from ciao.gmane.org (main.gmane.org [80.91.229.2]) by postgresql.org (Postfix) with ESMTP id 69E559FB3D4 for ; Thu, 12 Jul 2007 05:40:11 -0300 (ADT) Received: from root by ciao.gmane.org with local (Exim 4.43) id 1I8uDS-00067d-Jo for pgsql-performance@postgresql.org; Thu, 12 Jul 2007 10:40:02 +0200 Received: from pc035-72.amg.gda.pl ([153.19.72.35]) by main.gmane.org with esmtp (Gmexim 0.1 (Debian)) id 1AlnuQ-0007hv-00 for ; Thu, 12 Jul 2007 10:40:02 +0200 Received: from mstepnicki by pc035-72.amg.gda.pl with local (Gmexim 0.1 (Debian)) id 1AlnuQ-0007hv-00 for ; Thu, 12 Jul 2007 10:40:02 +0200 X-Injected-Via-Gmane: http://gmane.org/ To: pgsql-performance@postgresql.org From: =?iso-8859-2?q?Marcin_St=EApnicki?= Subject: one column from huge view Date: Thu, 12 Jul 2007 08:33:45 +0000 (UTC) Lines: 19 Message-ID: Mime-Version: 1.0 Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: 8bit X-Complaints-To: usenet@sea.gmane.org X-Gmane-NNTP-Posting-Host: pc035-72.amg.gda.pl User-Agent: pan 0.120 (Plate of Shrimp) X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200707/134 X-Sequence-Number: 25818 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? -- | And Do What You Will be the challenge | http://apcoln.linuxpl.org | So be it in love that harms none | http://biznes.linux.pl | For this is the only commandment. | http://www.juanperon.info `---* JID: Aragorn_Vime@jabber.org *---' http://www.naszedzieci.org