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 1ojj1C-0001eW-V5 for pgsql-hackers@arkaria.postgresql.org; Sat, 15 Oct 2022 15:24:07 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1ojj1B-0000O0-Qw for pgsql-hackers@arkaria.postgresql.org; Sat, 15 Oct 2022 15:24:05 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1ojj1B-0000Lm-2a for pgsql-hackers@lists.postgresql.org; Sat, 15 Oct 2022 15:24:05 +0000 Received: from mail-ej1-x631.google.com ([2a00:1450:4864:20::631]) by magus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_128_GCM_SHA256:128) (Exim 4.92) (envelope-from ) id 1ojj13-0001z7-KV for pgsql-hackers@lists.postgresql.org; Sat, 15 Oct 2022 15:24:04 +0000 Received: by mail-ej1-x631.google.com with SMTP id bj12so16189236ejb.13 for ; Sat, 15 Oct 2022 08:23:57 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=enterprisedb.com; s=google; h=content-transfer-encoding:in-reply-to:from:references:cc:to :content-language:subject:user-agent:mime-version:date:message-id :from:to:cc:subject:date:message-id:reply-to; bh=RUJBVD+nfAOuMpr1Nx/vuEZo7LBcKTR4uqVznl39W6Q=; b=g5giBlc/s95xzd3+4QCaIH4G7iMMLKyRlh80qInfmIbnQrh1v6X64Gna8DsAVQ0Q83 zZb1IEyBxk1lRMwlKe9NJfpXai2DzEIi61q46hEcO9wqSoZjuCgsPq0cmNSfAc1PcGFQ m7swrYF0gVcVc5gGf6wTS/7n6FOyDtm+BoCGNsMxtYHr1VrbMMD2dExOW9CN5QNpPtnJ dwHYgg3K53C7Up/7AORA+dJHvrJivC9QZUotZm9vBtTvSCSyivfALDJ2UP6/kbNyLZmA nSUx0SsGS3WYS+hJbHk3lqUe3wRMCbEw1m3j3FrvzLdfrEteWVLeKaJ84PpuaycoX+zn DFDQ== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20210112; h=content-transfer-encoding:in-reply-to:from:references:cc:to :content-language:subject:user-agent:mime-version:date:message-id :x-gm-message-state:from:to:cc:subject:date:message-id:reply-to; bh=RUJBVD+nfAOuMpr1Nx/vuEZo7LBcKTR4uqVznl39W6Q=; b=EWudCS5K8WpMLi2T/NT8SehmDUOVkw8nWffRPFfV4NDtJzN4l7IBOAKLtRWih6Ah4K lZo8N3CUrXTTwRirtUDl9d/k/RPnSOkwm3EbFZz/f5NYBn5ckCjFxZDzvQPtedVVtz1h bz7zJAPnc1yxmBjXpNM5PdOKcptLI+Ncbrdx3Tgn9F5mjr2F7MQ5YAQC1Ixdjm0hX292 fmsbE4l0+XpEt+MePZZrUe8thNLix0tP3R6/ftztalwahyLPQx90B85Jb1CDsaLgAxqD OC627i2DqYqIYuk93iDE39VOTopqyFy6sYWPgSGbTJFIV6mdpmVPsaX1Qwy9/p0rR8go uj/w== X-Gm-Message-State: ACrzQf0s90YLXTNe8y4wMn/fobAuOCIpd1IRG5Dy7423dlFNiyCGDzHa 7ZIspTzX7qdwjRv4aBLh3mWmNozNAeXK2O29bNpV39R4khj8K5mTfhh1hnKXTpd3v/O/xPchQtI v4nvJjesZtDv1KaH3l0Eb3VEfG7JzibbRCR1TJ461YhKXr0QEZi2cazjNsr4AVOqIzecpPEVn0p 0//lckdioX1zK2PotdTbH8RcAFPo7jkJ3o5nDpUXZBkfpAVENk06TFAMcKqAsohCWFOK65rlIFF 4G8K913OIzYUvHBxkyc+g9F7mr1yU3LREs2uHvIaB/Of5ouWYwri59QSI9A X-Google-Smtp-Source: AMsMyM5XgmGFNNmgkFlBsL+Ogxf1IyglzYDcZR5FFkuTlniSVyrXYbU64/QVeXkLfeH1sVcv4VyUVA== X-Received: by 2002:a17:906:7193:b0:78d:b87e:6aa5 with SMTP id h19-20020a170906719300b0078db87e6aa5mr2388733ejk.580.1665847436414; Sat, 15 Oct 2022 08:23:56 -0700 (PDT) Received: from [10.137.0.17] (ip-86-49-228-162.bb.vodafone.cz. [86.49.228.162]) by smtp.gmail.com with ESMTPSA id y11-20020a1709060a8b00b00788c622fa2csm3257507ejf.135.2022.10.15.08.23.55 (version=TLS1_3 cipher=TLS_AES_128_GCM_SHA256 bits=128/128); Sat, 15 Oct 2022 08:23:55 -0700 (PDT) Message-ID: Date: Sat, 15 Oct 2022 17:23:54 +0200 MIME-Version: 1.0 User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:102.0) Gecko/20100101 Thunderbird/102.3.1 Subject: Re: PATCH: Using BRIN indexes for sorted output Content-Language: en-US To: Zhihong Yu Cc: PostgreSQL Hackers References: From: Tomas Vondra In-Reply-To: Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: 7bit X-CLOUD-SEC-AV-Info: enterprisedb,google_mail,monitor X-CLOUD-SEC-AV-Sent: true X-Gm-Spam: 0 X-Gm-Phishy: 0 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk On 10/15/22 15:46, Zhihong Yu wrote: >... > 8) Parallel version is not supported, but I think it shouldn't be > possible. Just make the leader build the range info, and then let the > workers to acquire/sort ranges and merge them by Gather Merge. > ... > Hi, > I am still going over the patch. > > Minor: for #8, I guess you meant `it should be possible` . > Yes, I meant to say it should be possible. Sorry for the confusion. regards -- Tomas Vondra EnterpriseDB: http://www.enterprisedb.com The Enterprise PostgreSQL Company