Skip site navigation (1) Skip section navigation (2)

How far are projections pushed down the execution tree?

From: tmp <skrald(at)amossen(dot)dk>
To: pgsql-hackers(at)postgresql(dot)org
Subject: How far are projections pushed down the execution tree?
Date: 2010-03-02 10:31:58
Message-ID: hmiper$1sua$1@news.hub.org (view raw or flat)
Thread:
Lists: pgsql-hackers
Consider a table and a query referring to only a subset of the columns 
in that table. How early in the query evaluation is the projection 
carried out?

Are the columns to be selected filtered out as early as in the very 
access method that reads the table rows from the buffer, or are the 
projection handled later, after the whole row has been fetched by the 
access method?

Does it depend on the complexity of the query, how far down the three 
that the projection is handled out?

Thanks!

Responses

pgsql-hackers by date

Next:From: Asher HoskinsDate: 2010-03-02 10:47:03
Subject: to_timestamp() and quarters
Previous:From: Peter EisentrautDate: 2010-03-02 10:28:26
Subject: Re: function side effects

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group