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 1hJ53c-0002FR-VK for pgsql-hackers@arkaria.postgresql.org; Tue, 23 Apr 2019 23:42:37 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1hJ53b-0004DZ-D2 for pgsql-hackers@arkaria.postgresql.org; Tue, 23 Apr 2019 23:42:35 +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 1hJ53a-0004CP-VR for pgsql-hackers@lists.postgresql.org; Tue, 23 Apr 2019 23:42:35 +0000 Received: from mail-it1-x132.google.com ([2607:f8b0:4864:20::132]) by magus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1hJ53X-0003lH-VR for pgsql-hackers@lists.postgresql.org; Tue, 23 Apr 2019 23:42:34 +0000 Received: by mail-it1-x132.google.com with SMTP id u65so3197685itc.2 for ; Tue, 23 Apr 2019 16:42:31 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=2ndquadrant-com.20150623.gappssmtp.com; s=20150623; h=mime-version:references:in-reply-to:from:date:message-id:subject:to :cc; bh=1HwDxCECfHy3AQV3fFfs9kLhCkCdDQOFms27skVfn8c=; b=dglrfwaqKVbEKXORj/Rimc7no6JeiV/mQVGAHMhNT2tG9ySUokdXmKFPLvJuvPmVXq 6l5u6WfcKgu3fv43NOK4BW+gWRnviuNmJLG4bZdhwi4jOUANpx//PsLaS/oyAiDeLuUc IU2qHrMAn8LDpYld/xNQdhnqXtvrwLUOBm+1yHTDNYIBzu4i+aCuXrryc6px38H3DwvD EFvRV64HOqcQVeUj6adT1jmQUlUuW8hhTPTS1Gyz9YLL7FAKLsHWIlD5AJIhy16hPoVN jgOOX+2YssCoZAvQFwP4djUL6shT3NZb3LUBaN4yEs5zlokdbD+QFTttAjxHoz+ZemsC IK9w== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20161025; h=x-gm-message-state:mime-version:references:in-reply-to:from:date :message-id:subject:to:cc; bh=1HwDxCECfHy3AQV3fFfs9kLhCkCdDQOFms27skVfn8c=; b=L1GpubeBPfcOBkDWC0apQuGa2tG/pe8d5qhYGCp8ikpjtBV3jChhOpW3bKD8Di9j+s FlXcy16CzlCJ+Xbr2Zg15OY6FjIOZ/lvI+X/g+R0H0k4QEDUhg7ZAcCK+NO3hUgxjpmV dcKjUap84yzyGhU72t7gzSMIuW0o0KTRA1TqLNbmcG+Pwpy2W5CisOtWp3Tb7Cp5mVdR QYsyaNDDE4Cb8ByiOnNVepMAtZQpCx9ZGeP/LhC/Nupr+b30fUYEqvR8tr9hTMeZUkvu J03dbsVhGJHjUNwaVf0+XEpxyG8GOEn/KBX/3Dd4mA2+vVT1lUvBnS31DLQXno2ONQ4k D23g== X-Gm-Message-State: APjAAAV7tMnpghbofeWpgLB/oRQoyDQN06We7pVbwqzsRxItxCEyKBjk SrllPYX2OBgIywjzISmv1rguWhYgnDoigFhawwpz0Q== X-Google-Smtp-Source: APXvYqw0+iI5/NMmf5ZtCabURQuU1cfqnGKWRsFx2UKjU6p3ob+GXE20/MCq8U28suDbx5Muuu1kLxSgRZxM+U/tHMU= X-Received: by 2002:a24:58d:: with SMTP id 135mr4161109itl.3.1556062949677; Tue, 23 Apr 2019 16:42:29 -0700 (PDT) MIME-Version: 1.0 References: <001001d4f44b$2a2cca50$7e865ef0$@lab.ntt.co.jp> <2018.1555473241@sss.pgh.pa.us> <2923.1555474214@sss.pgh.pa.us> <17368.1555608352@sss.pgh.pa.us> In-Reply-To: From: David Rowley Date: Wed, 24 Apr 2019 11:42:10 +1200 Message-ID: Subject: Re: Runtime pruning problem To: Tom Lane Cc: Amit Langote , Yuzuko Hosoya , PostgreSQL Hackers Content-Type: text/plain; charset="UTF-8" List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk On Tue, 23 Apr 2019 at 01:12, David Rowley wrote: > I started working on this today and I've attached what I have so far. I've added this to the July commitfest so that I don't forget about it. https://commitfest.postgresql.org/23/2102/ -- David Rowley http://www.2ndQuadrant.com/ PostgreSQL Development, 24x7 Support, Training & Services