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.89) (envelope-from ) id 1h8fW4-0004xK-Hj for pgsql-hackers@arkaria.postgresql.org; Tue, 26 Mar 2019 06:24:56 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1h8fW2-0005bR-TU for pgsql-hackers@arkaria.postgresql.org; Tue, 26 Mar 2019 06:24:54 +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 ) id 1h8fW2-0005bK-MH for pgsql-hackers@lists.postgresql.org; Tue, 26 Mar 2019 06:24:54 +0000 Received: from mail.thelabyrinth.net ([45.56.70.56]) by magus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1h8fVv-0006Ce-P4 for pgsql-hackers@lists.postgresql.org; Tue, 26 Mar 2019 06:24:54 +0000 Received: from Davids-MacBook.local (unknown [41.169.120.100]) (using TLSv1.2 with cipher ECDHE-RSA-AES128-GCM-SHA256 (128/128 bits)) (No client certificate requested) (Authenticated sender: dsteele) by mail.thelabyrinth.net (Postfix) with ESMTPSA id 802A55466D; Tue, 26 Mar 2019 06:24:41 +0000 (UTC) Subject: Re: Tid scan improvements To: Edmund Horner Cc: Tom Lane , Andres Freund , David Rowley , Tomas Vondra , PostgreSQL Developers References: <24929.1547829356@sss.pgh.pa.us> <20190325215211.bhwf35lihihfdx5w@alap3.anarazel.de> <18054.1553554436@sss.pgh.pa.us> From: David Steele Message-ID: Date: Tue, 26 Mar 2019 08:24:30 +0200 User-Agent: Mozilla/5.0 (Macintosh; Intel Mac OS X 10.14; rv:60.0) Gecko/20100101 Thunderbird/60.6.0 MIME-Version: 1.0 In-Reply-To: Content-Type: text/plain; charset=utf-8; format=flowed Content-Language: en-US Content-Transfer-Encoding: 7bit List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk On 3/26/19 8:11 AM, Edmund Horner wrote: > On Tue, 26 Mar 2019 at 11:54, Tom Lane wrote: >> >> Andres Freund writes: >>> I was kinda hoping to keep block numbers out of the "main" APIs, to >>> avoid assuming everything is BLCKSZ based. I don't have a particular >>> problem allowing an optional setscanlimits type callback that works with >>> block numbers. The planner could check its presence and just not build >>> tid range scans if not present. Alternatively a bespoke scan API for >>> tid range scans, like the later patches in the tableam series for >>> bitmap, sample, analyze scans, might be an option. >> >> Given Andres' API concerns, and the short amount of time remaining in >> this CF, I'm not sure how much of this patch set we can expect to land >> in v12. It seems like it might be a good idea to scale back our ambitions >> and see whether there's a useful subset we can push in easily. > > I agree. It'll take some time to digest Andres' advice and write a > better patch. > > Should I set update CF app to a) set the target version to 13, and/or > move it to next commitfest? If you plan to continue working on it in this CF then you can just change the target to PG13. If you plan to take a break and pick up the work later then go ahead and push it to the next CF. Regards, -- -David david@pgmasters.net