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 1jLY69-0000mB-6C for pgsql-hackers@arkaria.postgresql.org; Mon, 06 Apr 2020 20:11:57 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1jLY68-0002sG-1Q for pgsql-hackers@arkaria.postgresql.org; Mon, 06 Apr 2020 20:11:56 +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 1jLY67-0002s9-QB for pgsql-hackers@lists.postgresql.org; Mon, 06 Apr 2020 20:11:55 +0000 Received: from mail-wr1-x444.google.com ([2a00:1450:4864:20::444]) by magus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_128_GCM_SHA256:128) (Exim 4.92) (envelope-from ) id 1jLY61-0004oU-0S for pgsql-hackers@lists.postgresql.org; Mon, 06 Apr 2020 20:11:55 +0000 Received: by mail-wr1-x444.google.com with SMTP id 65so1098246wrl.1 for ; Mon, 06 Apr 2020 13:11:48 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=2ndquadrant-com.20150623.gappssmtp.com; s=20150623; h=date:from:to:cc:subject:message-id:references:mime-version :content-disposition:in-reply-to; bh=d2XGlcC8/Au/ZEuL6FPfy3i6T5/FF5IKTBCxoniYJ8s=; b=pgrKjXbVupunGmrqfsVKwH5hnfvc8LWgrlNP6R+GLkDnz1CUS0f595T/h7JEbvX8ai slJO7PrcB4pUgIEtnNFtAUHjrGn3h6RDlD+6ptukemiDZQgBG/ozZuFP0g/8B7o2Yivz nbT/0Ug1N8MJPXyN3MlpwbhrrB3p2Nn6G9jQqyGPecwRUwdO1yVS+rnEdeceipgD6I9h 8hWFY2AJ32ncSdlRoZu6MptWJLtWHcgkXSvQSex9ezTqAh6jtUziQXkbogLNY9Ymb0Gl hJYC7VLSmVfINav7f9iYt1bYNf8QavbmcsJ3kSjeH+u0MSHJiZe8hXHPc+oJngRaAK91 ANZQ== 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=d2XGlcC8/Au/ZEuL6FPfy3i6T5/FF5IKTBCxoniYJ8s=; b=EEGbch3OmkesnVNUG1RAwX/60qKmfjve014z0p9v0/iEj9cwfcNagxd4Db6lI1Zi7t uyYPozXNd66d0NgIiRya/Dzh7h5iyFYTC3EJAd4799p6s7GOr2BCodhname9qBydrY8E tCH2jJ/EM/G/1fmodg54zELFpeFcVcuA9IHV3snqvOLHxYpnYaCoIa1Js7fWG4U6Zico hGwGDREurjFxRHrvuwp+AyNnjmxYdtu246vdR4LgTf1IWdRXwI0HbDOXOACIXy9nOK2Z yvFRQi0D/lzV7AMZKKx7GUsO4zlQjFxsjn2vTlFj5xQAK5IJjWrStEeuRXVVTvnQG1dO zOcg== X-Gm-Message-State: AGi0PubcznJMd9RIy+ftpuOsRuVOlWfNaENZpVXO/iISiZqXWNKyCXVF epXuuEDfBGNAs+8nr1KgJ5TKeQ== X-Google-Smtp-Source: APiQypLhf3MfsKw4X5MzKG7MCt74QzYsCkokf0p07R5to8eds3aHPnNKljkj5pVPE2AzbaZAWe/t1Q== X-Received: by 2002:a5d:4111:: with SMTP id l17mr1045073wrp.271.1586203907383; Mon, 06 Apr 2020 13:11:47 -0700 (PDT) Received: from localhost (ip-86-49-253-141.net.upcbroadband.cz. [86.49.253.141]) by smtp.gmail.com with ESMTPSA id y22sm1243205wma.0.2020.04.06.13.11.46 (version=TLS1_3 cipher=TLS_AES_256_GCM_SHA384 bits=256/256); Mon, 06 Apr 2020 13:11:46 -0700 (PDT) Date: Mon, 6 Apr 2020 22:11:45 +0200 From: Tomas Vondra To: James Coleman Cc: Tom Lane , Alvaro Herrera , Michael Paquier , Rafia Sabih , Peter Geoghegan , Simon Riggs , Shaun Thomas , Dmitry Dolgov <9erthalion6@gmail.com>, Alexander Korotkov , PostgreSQL Developers , Andreas Karlsson Subject: Re: [PATCH] Incremental sort (was: PoC: Partial sort) Message-ID: <20200406201145.ig56cdzrkt4u5mou@development> References: <20200401214215.ut6b72e3zlbm33w2@development> <20200402024746.5wlwk6q7eiv5faux@development> <20200403002028.kp3rxncmwvsui6xz@development> <20200405130110.2bdxaz4ed5jx2eae@development> <20200406195722.teiha6foiy3lix3s@development> MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii; format=flowed Content-Disposition: inline In-Reply-To: <20200406195722.teiha6foiy3lix3s@development> List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk On Mon, Apr 06, 2020 at 09:57:22PM +0200, Tomas Vondra wrote: >Hi, > >I've pushed the fist part of this patch series - I've reorganized it a >bit by moving the add_partial_path changes to the end. That way I've >been able to add regression test demonstrating impact of the change on >plans involving incremental sort nodes (which wouldn't be possible when >committing the add_partial_path first). I'll wait a bit before pushing >the two additional parts, so that if something fails we know which bit >caused it. > Hmmm, I see the buildfarm is not happy about it - a couple of animals failed, but some succeeded. The failure seems like a simple difference in explain output, but it's not clear why would it happen (and I've ran the tests many times but never seen this failure). Investigating. -- Tomas Vondra http://www.2ndQuadrant.com PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services