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 1njOgb-0006x7-9P for pgsql-admin@arkaria.postgresql.org; Tue, 26 Apr 2022 17:09: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 1njOgZ-00036R-Kd for pgsql-admin@arkaria.postgresql.org; Tue, 26 Apr 2022 17:09:11 +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 1njOgZ-00036H-7L for pgsql-admin@lists.postgresql.org; Tue, 26 Apr 2022 17:09:11 +0000 Received: from mail-oi1-x232.google.com ([2607:f8b0:4864:20::232]) by magus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_128_GCM_SHA256:128) (Exim 4.92) (envelope-from ) id 1njOgW-0005JK-Uo for pgsql-admin@postgresql.org; Tue, 26 Apr 2022 17:09:10 +0000 Received: by mail-oi1-x232.google.com with SMTP id q129so21392812oif.4 for ; Tue, 26 Apr 2022 10:09:08 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20210112; h=mime-version:from:date:message-id:subject:to; bh=QmGWjFW4jeR6qKwFB5chWXsAwTPvdU4rGyT+7MAAIPU=; b=GETe6xX72tTkWIXDG1BYbFiiSsjLo5hfWHYPAv3IVthmRekT5ifxL+cMbJIQhXAZZq LeJVvarnSWd4pcmQePjgIdX0AsNbQJVwNgC6klEknSUNLReJQFqJov0cUSs+wwri3+Tl ZsVLVGOM1SGa/MWP1CnGDq8vMT83TNz2tNXKI0BBirH/Bof2Z7BV5I+6qmVSPSkV01FJ 6is4ZiFfiCjpXDJhNxJcKzTMRBS0X4mOpHWWj5f413+g+XLmV9OnmmPuFzocveMSj4S1 f1WabVle+uVcSYYHpM3hl7rZv0hz5ulP/p09WGHQBfPUWgOv5M5s7fzv9s6ogxHdHqWF xeOA== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20210112; h=x-gm-message-state:mime-version:from:date:message-id:subject:to; bh=QmGWjFW4jeR6qKwFB5chWXsAwTPvdU4rGyT+7MAAIPU=; b=j2oH8dKdnhh9JVSHMyqDI/QA0NsU3YQgQr/7XCzPt7kkzmcyhHoslri+FLoKPh+d+5 xXlgG2xDzBFFMpvWfutrEWdDo9B+ttwprx+5f7fjZmYSJWj7V1jXtIhonSr+OyjXIA8M 70k82Dk3amycATCwHTLt54KGJp0WM2Ikfdj01siTR6l6hibTmdrwOmXyP/egcBVbqkZS +IGAVrmib+xv39JC4XUHIcXF2ekm5Sd5//+62nBPxs1TjrbSeypAwdDCjCtOSBqwTlZH E9UrNPdoFumgj1YGlMly3LGNmNRa/iCiYjZQ4vezL6et5yA0wNpIWbhkl3K2lvmrUXlF POAg== X-Gm-Message-State: AOAM532T3GLXiePR1jJoRF5o1e21G/Z9mlByuOkn0HigJtthV21Z1H/M QK+HQPQcpEvzUjno+25ErA0Z+4I0pyh9G/V13SqRF3Lf5NU= X-Google-Smtp-Source: ABdhPJxzaT5UNpoahej+8IcB4PrL6H/mJAivzWepW8tNcFU64bIiPJ1uRj3W2esU4NXx3Z+xtzK7BTNWyO3pg6vnM+8= X-Received: by 2002:a05:6808:1d7:b0:322:5866:9ee3 with SMTP id x23-20020a05680801d700b0032258669ee3mr10455524oic.171.1650992946871; Tue, 26 Apr 2022 10:09:06 -0700 (PDT) MIME-Version: 1.0 From: Wells Oliver Date: Tue, 26 Apr 2022 10:08:31 -0700 Message-ID: Subject: CTEs and temp_buffers? To: pgsql-admin Content-Type: multipart/alternative; boundary="0000000000002001c205dd91c048" List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --0000000000002001c205dd91c048 Content-Type: text/plain; charset="UTF-8" Out of curiosity, does the value of temp_buffers apply to how CTEs are generated under the hood? -- Wells Oliver wells.oliver@gmail.com --0000000000002001c205dd91c048 Content-Type: text/html; charset="UTF-8" Content-Transfer-Encoding: quoted-printable
Out of curiosity, does the value of temp_buffers apply to = how CTEs are generated under the hood?

-- <= br>
--0000000000002001c205dd91c048--