Mailing-List: contact dev-help@asterixdb.apache.org; run by ezmlm
Precedence: bulk
Reply-To: dev@asterixdb.apache.org
MIME-Version: 1.0
In-Reply-To: <CABytAGpLrFdkfLN5bWswuAdsi0Sv+X3MTrw5DvraNQ33vQcuMw@mail.gmail.com>
References: <CALjEsF7_r9X-du50pyKjqbXPTY5aAtrZYVcHntn86M5njx3hMA@mail.gmail.com>
 <CABytAGpLrFdkfLN5bWswuAdsi0Sv+X3MTrw5DvraNQ33vQcuMw@mail.gmail.com>
From: Yingyi Bu <buyingyi@gmail.com>
Date: Fri, 8 Jul 2016 13:43:54 -0700
Message-ID: <CALjEsF7AViDFS-acB2x3sZFf9tnwjSbZiBg2SXvKDqknZiR=qg@mail.gmail.com>
Subject: Re: questions about index-only change
To: Taewoo Kim <wangsaeu@gmail.com>
Cc: dev@asterixdb.incubator.apache.org
Content-Type: multipart/alternative; boundary=94eb2c0ba6ca68e268053725dcd9
archived-at: Fri, 08 Jul 2016 20:44:00 -0000

--94eb2c0ba6ca68e268053725dcd9
Content-Type: text/plain; charset=UTF-8

Cool, thanks a lot, Taewoo!

Best,
Yingyi

On Fri, Jul 8, 2016 at 1:36 PM, Taewoo Kim <wangsaeu@gmail.com> wrote:

> Sure. This is the design docs. There are some changes made and I need to
> reflect them. But, these can show the main design.
>
> Index-only
>
> https://docs.google.com/presentation/d/1HcoQwaTQu8K2Xdzg46RZP60LqON2oKnWkZx1z1buF1U/edit?usp=sharing
>
> Limit Push-down
>
> https://docs.google.com/presentation/d/1lvSLF9j7pcKo2nHkVoiOD9vNSFCNsVDGQYnYCdHhngk/edit?usp=sharing
>
> Regarding the numbers, I have collected some number in the past using
> Pouria's bigFun Benchmark. I have used my version of queries. The result is
> not based on the current design. The huge difference is now we are using
> instantTryLock, rather than tryLock. But you can still get a sense.
>
> https://docs.google.com/spreadsheets/d/1YuTuw24TUthr0YhEHMmGr9E4tCYAFxJjlg3S67zRY-M/edit?usp=sharing
>
>
>
>
> Best,
> Taewoo
>
> On Fri, Jul 8, 2016 at 1:09 PM, Yingyi Bu <buyingyi@gmail.com> wrote:
>
>> Hi Taewoo,
>>
>> I have a few questions regarding to your index-only change (I'm cc-ing to
>> dev just in case more people are interested in the topic.):
>>
>> 1. Is there any design doc or write up for the index-only change?
>>
>> 2. Do you have ddls/queries that are designed for the index-only
>> performance testing?  Do you have some initial performance numbers that
>> compare index-only plans and primary-index-access plans?
>>
>> Thanks!
>>
>> Yingyi
>>
>>
>>
>

--94eb2c0ba6ca68e268053725dcd9--