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 1ok5tp-0001uU-Ey for pgsql-hackers@arkaria.postgresql.org; Sun, 16 Oct 2022 15:50:01 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1ok5to-0007hl-Aq for pgsql-hackers@arkaria.postgresql.org; Sun, 16 Oct 2022 15:50:00 +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 1ok5to-0007hc-1t for pgsql-hackers@lists.postgresql.org; Sun, 16 Oct 2022 15:50:00 +0000 Received: from mail-ed1-x534.google.com ([2a00:1450:4864:20::534]) by makus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_128_GCM_SHA256:128) (Exim 4.92) (envelope-from ) id 1ok5tl-0006oN-Me for pgsql-hackers@lists.postgresql.org; Sun, 16 Oct 2022 15:49:59 +0000 Received: by mail-ed1-x534.google.com with SMTP id e18so12910720edj.3 for ; Sun, 16 Oct 2022 08:49: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=I9IPSTy8ZEhwJYWc30S2lVUrAEwCrNuOKOr3C1/HNZo=; b=ZHYIib6anrUJC8cvnXHNQHcXp0Trfm6FaRaESOQUrdNzVT5NPBtmcCeoy+Pg4cgd+n afBTLezE3O4Wh+a8zqGS2GtOTVlf/kX62ULOv94C0r+Ya26VQ2YdZvqNBZPTuxmZhmKz Wuv4Uu/iLkYy+yazXgIVIdgQzNsMFRSiHSbTdDnpARpk6Fgnbeq6LYw4n1eNJWT/TeAV kK5II8CFOaoLO70FWzKLHD/6XzJDgjXX4OIjwBJ35t/KI3xWh6ADBpL1GtHQxW92E7u5 W8OW2R72baOHWWgGeyCzG6TAEVajkJ9HMbNIqKxe/BJXqJ15mGwpxbw7Fn1wyaW+GkbI 3DmA== 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=I9IPSTy8ZEhwJYWc30S2lVUrAEwCrNuOKOr3C1/HNZo=; b=Q8WO1lMekiqTpA7fQc+bK6c6ki1EZpJSqLnV8fSwPSnkUN2oWTXGT911XuYleeeR+M Q7ipfdNfAeFiqDHASORNPuhPgSU7Nf4qQF+qtZCEDHvsJnzKKSURB5cyfiPlUplzJK/B f49gd2WYlQZtweyXWLOsKaIN0peC8HHfiGhWlcYOyUWD/WOMxX5mhaOzZW4NyO279rwK bCKlgH84JxdqgSfQ2M8z/TfQNrjLreQjm8rRtZqF6u25GIoO6jHivzuNNLImWDOgKZUY j5RfZGvS3D3tLdCBM/xv7V0a5ZDAp7U5AZOplBHg5AuCIhRF59vcq9y+YDfddsh/9wve +eyw== X-Gm-Message-State: ACrzQf3fdu4ZqJaAQJ7vU9uy26ikFEQ5sgDGrN8Ce7Fx9RBI13CLTv6d t0nn1vPq9vZM3/cq0GvqXOhi5eRoqVh++aGCQ94uh8O5PVxotbUwfszZ8bCsp6yJDOGEssGlvtm Iu0SFIyRKAhSYb+ZUdwk6XNMBcPIsoGCn1zx05copKpvXq64gXJs3beBhp3TypK2dtFiHBcHWoh KQzm08xlh77yneeGQo6bMlpXgB10sPxw7IYgOjlprEuEOeL3QbaHGJWdwZAbzgsY30oRBNZB9vH 7n+FqPtwarUrkiARX80SU9AVLni4g6l2XgcAbGuuGBNtu64nXjYMlY6YYfxAgj/rwBT X-Google-Smtp-Source: AMsMyM53GJzpOGI5/EqF0YnSlP1Ks7R3MXFQPxvCXwAhITRDCfx/jOGagtyfadN0wbagsWDJG5QTuw== X-Received: by 2002:a05:6402:3454:b0:45c:a8b0:52d2 with SMTP id l20-20020a056402345400b0045ca8b052d2mr6795451edc.307.1665935396231; Sun, 16 Oct 2022 08:49: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 q7-20020a170906540700b0078d9cd0d2d6sm4888326ejo.11.2022.10.16.08.49.55 (version=TLS1_3 cipher=TLS_AES_128_GCM_SHA256 bits=128/128); Sun, 16 Oct 2022 08:49:55 -0700 (PDT) Message-ID: <04019ce2-b036-b388-286a-3520d9e7f896@enterprisedb.com> Date: Sun, 16 Oct 2022 17:49:55 +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: <1a7c2ff5-a855-64e9-0272-1f9947f8a558@enterprisedb.com> <1607e037-8c5b-1626-9f98-496f067b9eb5@enterprisedb.com> 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/16/22 16:42, Zhihong Yu wrote: > ... > > I don't have good answer w.r.t. splitting the page range [0,127] now. > Let me think more about it. > Sure, no problem. > The 10 step flow (subject to changes down the road) should be either > given in the description of the patch or, written as comment inside the > code. > This would help people grasp the concept much faster. True. I'll add it to the next version of the pach. regards -- Tomas Vondra EnterpriseDB: http://www.enterprisedb.com The Enterprise PostgreSQL Company