Return-Path: X-Original-To: archive-asf-public-internal@cust-asf2.ponee.io Delivered-To: archive-asf-public-internal@cust-asf2.ponee.io Received: from cust-asf.ponee.io (cust-asf.ponee.io [163.172.22.183]) by cust-asf2.ponee.io (Postfix) with ESMTP id 5A7A4200B5C for ; Thu, 11 Aug 2016 23:46:46 +0200 (CEST) Received: by cust-asf.ponee.io (Postfix) id 58FD2160A93; Thu, 11 Aug 2016 21:46:46 +0000 (UTC) Delivered-To: archive-asf-public@cust-asf.ponee.io Received: from mail.apache.org (hermes.apache.org [140.211.11.3]) by cust-asf.ponee.io (Postfix) with SMTP id 9F408160A90 for ; Thu, 11 Aug 2016 23:46:45 +0200 (CEST) Received: (qmail 86410 invoked by uid 500); 11 Aug 2016 21:46:44 -0000 Mailing-List: contact dev-help@asterixdb.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: dev@asterixdb.apache.org Delivered-To: mailing list dev@asterixdb.apache.org Received: (qmail 86394 invoked by uid 99); 11 Aug 2016 21:46:44 -0000 Received: from pnap-us-west-generic-nat.apache.org (HELO spamd3-us-west.apache.org) (209.188.14.142) by apache.org (qpsmtpd/0.29) with ESMTP; Thu, 11 Aug 2016 21:46:44 +0000 Received: from localhost (localhost [127.0.0.1]) by spamd3-us-west.apache.org (ASF Mail Server at spamd3-us-west.apache.org) with ESMTP id 24FE1189D0A for ; Thu, 11 Aug 2016 21:46:44 +0000 (UTC) X-Virus-Scanned: Debian amavisd-new at spamd3-us-west.apache.org X-Spam-Flag: NO X-Spam-Score: 1.179 X-Spam-Level: * X-Spam-Status: No, score=1.179 tagged_above=-999 required=6.31 tests=[DKIM_SIGNED=0.1, DKIM_VALID=-0.1, DKIM_VALID_AU=-0.1, HTML_MESSAGE=2, RCVD_IN_DNSWL_LOW=-0.7, RCVD_IN_MSPIKE_H3=-0.01, RCVD_IN_MSPIKE_WL=-0.01, SPF_PASS=-0.001] autolearn=disabled Authentication-Results: spamd3-us-west.apache.org (amavisd-new); dkim=pass (2048-bit key) header.d=gmail.com Received: from mx1-lw-us.apache.org ([10.40.0.8]) by localhost (spamd3-us-west.apache.org [10.40.0.10]) (amavisd-new, port 10024) with ESMTP id 2rDsy4iFOoHb for ; Thu, 11 Aug 2016 21:46:43 +0000 (UTC) Received: from mail-ua0-f180.google.com (mail-ua0-f180.google.com [209.85.217.180]) by mx1-lw-us.apache.org (ASF Mail Server at mx1-lw-us.apache.org) with ESMTPS id EC37C5FCCF for ; Thu, 11 Aug 2016 21:46:42 +0000 (UTC) Received: by mail-ua0-f180.google.com with SMTP id k90so14551056uak.1 for ; Thu, 11 Aug 2016 14:46:42 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20120113; h=mime-version:in-reply-to:references:from:date:message-id:subject:to; bh=htsY5LX6iCxknoCjandnjNKOIjetKut13Ko4z7hOsvE=; b=qLdMsmZAmRQ7cgXC4CnDnH+30Gz8YAuTt2k4kS50HxNqi2uqL0x0kZFAdYzCspHpKR sRbR5HAJS7gFFfZtkcklec3bY52Xp2FPtJibARdG9hzaAfkMN0vM/Vk/R6Mz2ZHjpZ/1 V/vU4fYQV9gn/doPn4l7lBAKHniKoELpHhzSnyIdE/8W5qPoqn2nk4pc/nQTCIOQndSc MqeDYkz7Um4gLbxxqspeyruy4Rv7s1mj1+EGUpTO7SDa5DCNLVdgnRyvpXEm/mymzuIC HitXVV+Qjw9x7qMG8RhOxCCizHWuS97qBIHUEgbZwOlnCTKqnUFnpPPr3YGCVjrTVD76 nElA== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20130820; h=x-gm-message-state:mime-version:in-reply-to:references:from:date :message-id:subject:to; bh=htsY5LX6iCxknoCjandnjNKOIjetKut13Ko4z7hOsvE=; b=d3F1XoE4EwcgXyyAmmvGE1VHpWutK5oMVxShg8Kqr+E8vIoUSm4pub1dGxJkCUSE5m o3oM1J5NK2MYhIhx+2807dk1Zmv6ESL/Dm5d6gIhm4QamuE3C/Jd327izE07wIof4ZxQ XIvzqYKWSNOAwoFWjnyzBvmH9lZ3rlGXwpyuYWNLbRfGQNIV+u5F4ruJuRHJh54uCdD1 oIORiOHSDhG4YouHW31BinmWMBMDbr4TNd2BObfvBgMiTTxCHdLWPT7SC8/BJ+cg/KGq g6NFddkNc2tKTHXqjLkOt1wDw2uq5FNJ7uU6mDvHGL5dL41Pxwr7xvQh8rcTgzHILnul dv4Q== X-Gm-Message-State: AEkoouusiHEOofGSRQymhMSWm+G8W8VR1G8jwXOxQuWh+R3Rz4BR56TTYQy0I9NU7ewEo8f34QcQF6tsoufs7w== X-Received: by 10.31.9.67 with SMTP id 64mr5879865vkj.89.1470952002424; Thu, 11 Aug 2016 14:46:42 -0700 (PDT) MIME-Version: 1.0 Received: by 10.176.80.147 with HTTP; Thu, 11 Aug 2016 14:46:21 -0700 (PDT) In-Reply-To: References: From: Taewoo Kim Date: Thu, 11 Aug 2016 14:46:21 -0700 Message-ID: Subject: Re: index-only plans To: dev@asterixdb.apache.org Content-Type: multipart/alternative; boundary=001a11440ef496149c0539d2b3ab archived-at: Thu, 11 Aug 2016 21:46:46 -0000 --001a11440ef496149c0539d2b3ab Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: quoted-printable Thanks Till for reviewing this giant patch set. At this moment, what I can try to do is removing all necessary test cases and changes that are related to full-text search preparation (changing the function name of "contains" to "string-contains") since I thought this index-only plan branch could be merged first. I tried to separate logical LIMIT push-down to the index search and index-only plan. But, it turns out that it was hard. Other than this, all changes are related to index-only plan part (most of them are accessMethod related.) In addition, Young-Seok already had one round. Best, Taewoo On Thu, Aug 11, 2016 at 2:43 PM, Till Westmann wrote: > Hi, > > we still have the big change on index-only plans outstanding. I think tha= t > it would be good to have that feature. However, at it=E2=80=99s current s= ize (+45K > lines, -15K lines) it is very (!) difficult to review. So I think that on= e > approach to get there would be to break it down into smaller more > achievable > steps. > I=E2=80=99ve added a few comments to the review with thoughts I had to do= that. > What do you think? > Is that a good approach? Is it feasible? > Are there other ways? > > Thanks for your thoughts, > Till > --001a11440ef496149c0539d2b3ab--