Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.92) (envelope-from ) id 1jGmc4-0008Kq-S3 for pgsql-hackers@arkaria.postgresql.org; Tue, 24 Mar 2020 16:41:13 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1jGmc3-0006wP-Ny for pgsql-hackers@arkaria.postgresql.org; Tue, 24 Mar 2020 16:41:11 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from <9erthalion6@gmail.com>) id 1jGmc3-0006wI-FD for pgsql-hackers@lists.postgresql.org; Tue, 24 Mar 2020 16:41:11 +0000 Received: from mail-wr1-x443.google.com ([2a00:1450:4864:20::443]) by magus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_128_GCM_SHA256:128) (Exim 4.92) (envelope-from <9erthalion6@gmail.com>) id 1jGmc1-0005f1-GS for pgsql-hackers@postgresql.org; Tue, 24 Mar 2020 16:41:11 +0000 Received: by mail-wr1-x443.google.com with SMTP id h15so10127785wrx.9 for ; Tue, 24 Mar 2020 09:41:09 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20161025; h=date:from:to:cc:subject:message-id:references:mime-version :content-disposition:in-reply-to; bh=XlnDI41wulNf0LcGB6nHjkSkY6rucpo71oc8QrLF6Ko=; b=iMZZd9xHKZYhsvNNW6MIsCO7+5PNuNQW9E8XNCsH+3w4bA0cDfPXxEdmUlAizP2mSJ wDMPjVzrxp9lMr3XngL4ISSDr2HV0FgIavFEAbJTo9pBbKcNvxd3FBhagLXNtjsbouSP djnlEN1SFLoqBT1H085GHykcHWv3SDaYvxfiZ7jBSuOoTSeZk8n8YFf+g+2ssNswRWQf ByDrgtp8TI/oHq0avfyh4/Uhkpa3Th245P910ljTL4/DhUNeGv1kci4N/FcS/X2xG0QY JhZyoGl8rFhAaQ01IPar+ESsrgURD0NRDxlKCyMFHFxpkFlWW44V9Qj2ui0AQspaa8zh flDA== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20161025; h=x-gm-message-state:date:from:to:cc:subject:message-id:references :mime-version:content-disposition:in-reply-to; bh=XlnDI41wulNf0LcGB6nHjkSkY6rucpo71oc8QrLF6Ko=; b=n3dyru89U3/zoq17KN0yhRK0ZaPsVyfeu9UFs+Uj9OGqAM+ZacALLe0hCbV45cBP9D QcFOlypl+GGMx+RcjccxGV5TNwdQbAayDQnihxz+plYQ0CRzZk3UtA7lkCbU4hJnboqf HzrShkOOZ6b23bMmkVDvijdPkWKNtMNvquLGjTO4rCzEW4/4V3PnoPH+vhwe1lLOGpKy EimrGLsqXlD7ON8djllecbMv70+Zu32+NDEJvpGQCetojvGUJ3XKbW+72TCfGsDFcdCs z/qoE3xZk/GwFq41Oy33zKdPFUMcfVJTo+KQoSSxon00JH7fwzXneXSzu1ru5C0gyZox beAQ== X-Gm-Message-State: ANhLgQ0zVpEgo28iuxZ0yrF7aoxx2aQhd7OtcQoUoEOmy+oiza+NHmnL cJiL+mXzds7ZiPZLbQuT1oQ= X-Google-Smtp-Source: ADFU+vugH+8kJXILGOITVucQ23Z3SlW6sYrS9j7Kcaybj3Kb5qvXwSLvTi2tnMgn0A7KXEC9Z+OI1w== X-Received: by 2002:adf:a387:: with SMTP id l7mr37511756wrb.250.1585068068631; Tue, 24 Mar 2020 09:41:08 -0700 (PDT) Received: from localhost (dslb-094-222-004-201.094.222.pools.vodafone-ip.de. [94.222.4.201]) by smtp.gmail.com with ESMTPSA id q10sm29522139wrx.12.2020.03.24.09.41.06 (version=TLS1_2 cipher=ECDHE-RSA-AES128-GCM-SHA256 bits=128/128); Tue, 24 Mar 2020 09:41:08 -0700 (PDT) Date: Tue, 24 Mar 2020 17:42:21 +0100 From: Dmitry Dolgov <9erthalion6@gmail.com> To: Andy Fan Cc: James Coleman , David Rowley , Kyotaro Horiguchi , Tomas Vondra , Floris Van Nee , Peter Geoghegan , Jesper Pedersen , Alvaro Herrera , Thomas Munro , Rafia Sabih , Jeff Janes , Bhushan Uparkar , PostgreSQL-development , Alexander Korotkov Subject: Re: Index Skip Scan Message-ID: <20200324164221.jsvlctinyq23ofxj@localhost> References: <20200208131159.5sjcbcjnwdj4q7fa@development> <20200214.172313.259958375378013155.horikyota.ntt@gmail.com> <20200214121820.xvvrkdbykkygfs65@localhost> <20200217162451.nrpy5k63f5y2mwm6@localhost> <20200308142228.3zb237cd3oedspl2@localhost> <20200309195714.eum3b6e5mogqj3gm@localhost> MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk > On Wed, Mar 11, 2020 at 06:56:09PM +0800, Andy Fan wrote: > > There was a dedicated thread [1] where David explain his idea very > detailed, and you can also check that messages around that message for > the context. hope it helps. Thanks for pointing out to this thread! Somehow I've missed it, and now looks like we need to make some efforts to align patches for index skip scan and distincClause elimination.