Re: Identity projection

From: Kyotaro HORIGUCHI <horiguchi(dot)kyotaro(at)lab(dot)ntt(dot)co(dot)jp>
To: tgl(at)sss(dot)pgh(dot)pa(dot)us
Cc: pgsql-hackers(at)postgresql(dot)org
Subject: Re: Identity projection
Date: 2012-09-14 07:26:04
Message-ID: 20120914.162604.152376784.horiguchi.kyotaro@lab.ntt.co.jp
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Although I said as following, the gain seems a bit larger... I'll
recheck the testing conditions...

> > Another point here is that the projection code already special-cases
> > simple projections, so it's a bit hard to believe that it's as slow as
> > you suggest above. I wonder if your test case is confusing that
> > optimization somehow.
>
> The whole table is on memory and query is very simple and the
> number of columns is relatively larger in this case. This is
> because I intended to improve retrieving a large part of
> partitioned table with many columns.

--
Kyotaro Horiguchi
NTT Open Source Software Center

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Etsuro Fujita 2012-09-14 07:48:50 Re: WIP patch: add (PRE|POST)PROCESSOR options to COPY
Previous Message Feridun türk 2012-09-14 06:22:33