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 1nXPxZ-0005D0-DJ for pgsql-hackers@arkaria.postgresql.org; Thu, 24 Mar 2022 16:05:13 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1nXPxY-0000yt-4F for pgsql-hackers@arkaria.postgresql.org; Thu, 24 Mar 2022 16:05:12 +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 1nXPxX-0000yj-RU for pgsql-hackers@lists.postgresql.org; Thu, 24 Mar 2022 16:05:11 +0000 Received: from mail-oi1-x230.google.com ([2607:f8b0:4864:20::230]) by magus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_128_GCM_SHA256:128) (Exim 4.92) (envelope-from ) id 1nXPxU-0000SA-GT for pgsql-hackers@postgresql.org; Thu, 24 Mar 2022 16:05:10 +0000 Received: by mail-oi1-x230.google.com with SMTP id q129so5338606oif.4 for ; Thu, 24 Mar 2022 09:05:08 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=enterprisedb.com; s=google; h=mime-version:references:in-reply-to:from:date:message-id:subject:to :cc; bh=lp9riYKDVidi4zuC2d1/xW4ZFrmhxmDiAcLo1uIeW6M=; b=KwavHITzriNz1aiVstaKpEnEjqMnzVrK70ZYy0LMfTN7yvxyng6qyP8GKWaE4AYC9g YLpt8EADoz8RL4qToZ8WfiFqlqYiriJD7Jcwrwxj4KjS4nSp7lB+4rnPLiHZ2VrGNbb6 jgROrTJHVldcmGP8vXTi85FDBtcXIK4wNgsaAsyckNdUEgNDUDfB7wlT8Dcs7y3oC+Sa bWMPgGPknvGL+ljRz2iK7qPncanrbglXRZ7q+bzHtL5bQBoQY2IEH0Hrlq7F6tQDVmJN ICTEaf85Va170ZL1DUF6cBKnnQf0xOxyH5VNsnAllAeJN+1hlYoSSBRbvyvvxxt2FH0B fOkA== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20210112; h=x-gm-message-state:mime-version:references:in-reply-to:from:date :message-id:subject:to:cc; bh=lp9riYKDVidi4zuC2d1/xW4ZFrmhxmDiAcLo1uIeW6M=; b=xIWR3oWc4U4pyrwhlvA9sY0vVjkknR7uiiupAkvDcGuI7WodWzq6F8kY1HpLFBOnnf vCOF/CY7z9gtT7cAjWNrcRTBGFDQ+3yIsq4C3B5IbeWluJ133BWf9FpEb0oBUVWTxtgg aU0qDWwP/7KsQkIT9DSQnGWROfyNflC8HCEBJRqgzomRfsRxB9OUxvsc6Pzs3GwaLmD+ vkrk33jAokpuo0V/VwbUCvrMRQKM4kUGz3xwp1Jeir+UjjOdAutL7HCDi/8N3IC3wPf9 Iom91tau3f/oTC3ifMSgu4VSNMP8smzdoleX23QJTmDrBCdi86Qhk28iT83A43jxMETG ytzw== X-Gm-Message-State: AOAM5307LuYI8UySwdykSQEBy9BmGyf2dKfxYsgoELo1Ni4aj9Xl9jQd 1JLRZ5xEV0EkA8YGY0mZVY3SopSLv7gNz8PI9/YdQFEoPiQKWNxAP4RkHhytSuetbc4oTX3NWLP kPSH7WKrh4zAPHcXveX0gyZX/kVjYKpKqEnZ2E64FKHU2Mafq/pUPnZoqejuGDNt6fDMq5UJbm7 sw0I57/xBavPQ2fsJqxwb8MlI4gL1SbmDIh4eGDtke9SpWgmK2bCDp X-Google-Smtp-Source: ABdhPJzgHHVm2nnz6xqErHIKA+/6AI9OyP2UFqJbXtXpNWr+dXFE/2JWASHyuI0Zl+mnouMm2aK4I4DfaHXW9lQEMdQ= X-Received: by 2002:a05:6808:20a7:b0:2da:5fcb:29b2 with SMTP id s39-20020a05680820a700b002da5fcb29b2mr3067950oiw.82.1648137906312; Thu, 24 Mar 2022 09:05:06 -0700 (PDT) MIME-Version: 1.0 References: <91533bcd-c3a3-5844-7449-43aceede2117@enterprisedb.com> <2770446.1648056989@sss.pgh.pa.us> <2796462.1648067136@sss.pgh.pa.us> <3014852.1648136901@sss.pgh.pa.us> In-Reply-To: <3014852.1648136901@sss.pgh.pa.us> From: Simon Riggs Date: Thu, 24 Mar 2022 16:04:55 +0000 Message-ID: Subject: Re: Parameter for planner estimate of recursive queries To: Tom Lane Cc: Robert Haas , Peter Eisentraut , PostgreSQL Hackers Content-Type: text/plain; charset="UTF-8" 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 Thu, 24 Mar 2022 at 15:48, Tom Lane wrote: > > Simon Riggs writes: > > On Wed, 23 Mar 2022 at 20:25, Tom Lane wrote: > >> Do you have any objection if I rename the GUC to > >> recursive_worktable_factor? That seems a bit clearer as to what > >> it does, and it leaves more room for other knobs in the same area > >> if we decide we need any. > > > None, I think your proposal is a better name. > > Pushed that way. Ok, thanks. -- Simon Riggs http://www.EnterpriseDB.com/