Thread: Re: [Postgres-xc-developers] Fetching only the required columns

So in FQS we already have column projection?
---
Koichi

On Thu, 24 May 2012 15:36:32 +0530
Ashutosh Bapat <ash...@en...> wrote:

> Hi All,
> PFA the patch to fetch only the required columns from the datanode. Right
> now, we fetch all the columns of a table from datanode in many cases. Also
> modified test outputs which had diffs because of EXPLAIN output.
> 
> I am expecting this patch to give a little performance improvement when a
> query is not FQSed, since the data fetched from the remote tables is
> reduced.
> 
> Since this has not much impact on the code or regression, I would commit it
> only to master branch.
> 
> -- 
> Best Wishes,
> Ashutosh Bapat
> EntepriseDB Corporation
> The Enterprise Postgres Company

On Thu, May 24, 2012 at 6:50 AM, Koichi Suzuki <ko...@in...>wrote:

> So in FQS we already have column projection?
>

FQS ships the whole query as it is, so it automatically fetches only
required data.


> ---
> Koichi
>
> On Thu, 24 May 2012 15:36:32 +0530
> Ashutosh Bapat <ash...@en...> wrote:
>
> > Hi All,
> > PFA the patch to fetch only the required columns from the datanode. Right
> > now, we fetch all the columns of a table from datanode in many cases.
> Also
> > modified test outputs which had diffs because of EXPLAIN output.
> >
> > I am expecting this patch to give a little performance improvement when a
> > query is not FQSed, since the data fetched from the remote tables is
> > reduced.
> >
> > Since this has not much impact on the code or regression, I would commit
> it
> > only to master branch.
> >
> > --
> > Best Wishes,
> > Ashutosh Bapat
> > EntepriseDB Corporation
> > The Enterprise Postgres Company
>



-- 
Best Wishes,
Ashutosh Bapat
EntepriseDB Corporation
The Enterprise Postgres Company