Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1nXLod-0000NU-KO for pgsql-hackers@arkaria.postgresql.org; Thu, 24 Mar 2022 11:39:43 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1nXLob-0001vE-0K for pgsql-hackers@arkaria.postgresql.org; Thu, 24 Mar 2022 11:39:41 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1nXLoa-0001v4-NA for pgsql-hackers@lists.postgresql.org; Thu, 24 Mar 2022 11:39:40 +0000 Received: from us-smtp-delivery-124.mimecast.com ([170.10.133.124]) by makus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1nXLoY-0004Sx-6g for pgsql-hackers@postgresql.org; Thu, 24 Mar 2022 11:39:39 +0000 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=redhat.com; s=mimecast20190719; t=1648121977; h=from:from:reply-to:reply-to:subject:subject:date:date: message-id:message-id:to:to:cc:cc:mime-version:mime-version: content-type:content-type: content-transfer-encoding:content-transfer-encoding: in-reply-to:in-reply-to:references:references; bh=9egWts1iUOZr/w/8rGrlTp2aZqzFcD6MC2b12UnEcK0=; b=d96AMlmcUt+9eBdBmjJlAt2J3+E5u4MgoBfAAz88qxrZuIwFBrCwS3/lH9T4Mynmp1g84T iaWRo6uSc+zWspoUpvPnrRGmj9gJ1XTQEo5KbdB3uoEy5v3yfiwd4CPW152z7CPC9G7Bgx O/66rIA7ZABhQrPN2b80yZP7q0ymSpU= Received: from mail-qv1-f69.google.com (mail-qv1-f69.google.com [209.85.219.69]) by relay.mimecast.com with ESMTP with STARTTLS (version=TLSv1.2, cipher=TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384) id us-mta-654-y2bs4EKWPHGCT_n6_Es7YA-1; Thu, 24 Mar 2022 07:39:34 -0400 X-MC-Unique: y2bs4EKWPHGCT_n6_Es7YA-1 Received: by mail-qv1-f69.google.com with SMTP id hu9-20020a056214234900b0042c4017aeb3so3392393qvb.14 for ; Thu, 24 Mar 2022 04:39:34 -0700 (PDT) X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20210112; h=x-gm-message-state:message-id:date:mime-version:user-agent:reply-to :subject:content-language:to:cc:references:from:organization :in-reply-to:content-transfer-encoding; bh=9egWts1iUOZr/w/8rGrlTp2aZqzFcD6MC2b12UnEcK0=; b=MFSlAvXy1f3A4vlC2PpLlWGJeC2osPFumqwO+kXsopdsh7zlCsO+Yhl8mof6iaMQVX 0bQSJANftdcR8yajhr5gDbuFgBlv2+aqzbQ1EqQy9UgxpcSOutTbzTBKn927B6b5RHNW zUUmKrxdqZlJH4A5KOwpmn95oBr02eDL4JpWgUc7ypqlK0FhMcgJX+kGbMYfSU6Fa0uy 7fEcud5S0jmPQXq+sqv3y8BSlFOg1SZidYUam694tGJ/7R//t1TO3EsHedOA7ISybnmT o2hwEANSgN6LOes0eaf8zLLol3NZhy9wjuIzE5U8f9tRpxNV7Rn1BUenGdArZO0iIlPd rlhw== X-Gm-Message-State: AOAM5300Y5ka7XSoSvjq90xf3fLTz3VQOC5AFYpLII5jXltPLOHHzF+w r4WBVRYkpOX+Tx1UsW4BVpKyYs2EW62BXqulrhK0oJ1/eeSZ6xeASts3PwFcFqKjTnpO+N9/u9G YSOvSh9S/sZnuj6gYR686pwbELPM+RmsjEiZvRXUMMFZ+Sxg8w42EsQYdiJ+Fq93iUtvsFmbNB6 7ZhEg4cUl1tA== X-Received: by 2002:ac8:5890:0:b0:2e2:fdb9:da5 with SMTP id t16-20020ac85890000000b002e2fdb90da5mr871589qta.288.1648121973519; Thu, 24 Mar 2022 04:39:33 -0700 (PDT) X-Google-Smtp-Source: ABdhPJxOjF38qGy749Al8I9Mgz+ey+hTXej0Y1+ScUZ9VxnBLt4qUWBH4XL/5qDPmoajshcK9uCzhw== X-Received: by 2002:ac8:5890:0:b0:2e2:fdb9:da5 with SMTP id t16-20020ac85890000000b002e2fdb90da5mr871566qta.288.1648121973237; Thu, 24 Mar 2022 04:39:33 -0700 (PDT) Received: from [192.168.1.18] (c-24-61-8-151.hsd1.ma.comcast.net. [24.61.8.151]) by smtp.gmail.com with ESMTPSA id o14-20020a05622a138e00b002e1e78c899fsm2395986qtk.53.2022.03.24.04.39.32 (version=TLS1_3 cipher=TLS_AES_128_GCM_SHA256 bits=128/128); Thu, 24 Mar 2022 04:39:32 -0700 (PDT) Message-ID: Date: Thu, 24 Mar 2022 07:39:31 -0400 MIME-Version: 1.0 User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:91.0) Gecko/20100101 Thunderbird/91.7.0 Reply-To: jesper.pedersen@redhat.com Subject: Re: Index Skip Scan (new UniqueKeys) To: PostgreSQL-development Cc: David Rowley , Floris Van Nee , Kyotaro Horiguchi , Peter Geoghegan , Thomas Munro , Tomas Vondra , Andy Fan , Dilip Kumar , Dmitry Dolgov <9erthalion6@gmail.com> References: <20200609102247.jdlatmfyeecg52fi@localhost> From: Jesper Pedersen Organization: Red Hat In-Reply-To: <20200609102247.jdlatmfyeecg52fi@localhost> Authentication-Results: relay.mimecast.com; auth=pass smtp.auth=CUSA124A263 smtp.mailfrom=jesper.pedersen@redhat.com X-Mimecast-Spam-Score: 0 X-Mimecast-Originator: redhat.com Content-Language: en-US Content-Type: text/plain; charset=UTF-8; format=flowed Content-Transfer-Encoding: 7bit List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk On 6/9/20 06:22, Dmitry Dolgov wrote: > Here is a new version of index skip scan patch, based on v8 patch for > UniqueKeys implementation from [1]. I want to start a new thread to > simplify navigation, hopefully I didn't forget anyone who actively > participated in the discussion. > This CommitFest entry has been closed with RwF at [1]. Thanks for all the feedback given ! [1] https://www.postgresql.org/message-id/ab8636e7-182f-886a-3a39-f3fc279ca45d%40redhat.com Best regards, Dmitry & Jesper