asterixdb-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Yingyi Bu <buyin...@gmail.com>
Subject Re: questions about index-only change
Date Fri, 08 Jul 2016 20:43:54 GMT
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
>>
>>
>>
>

Mime
  • Unnamed multipart/alternative (inline, None, 0 bytes)
View raw message