Re: CTEs and temp_buffers?

From: Bruce Momjian <bruce(at)momjian(dot)us>
To: Wells Oliver <wells(dot)oliver(at)gmail(dot)com>
Cc: pgsql-admin <pgsql-admin(at)postgresql(dot)org>
Subject: Re: CTEs and temp_buffers?
Date: 2022-04-26 17:48:21
Message-ID: YmgwZfuUCZwctrsC@momjian.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

On Tue, Apr 26, 2022 at 10:08:31AM -0700, Wells Oliver wrote:
> Out of curiosity, does the value of temp_buffers apply to how CTEs are
> generated under the hood?

To see temp file usage, you can enable log_temp_files, and check the
server logs or enable client_min_messages.

--
Bruce Momjian <bruce(at)momjian(dot)us> https://momjian.us
EDB https://enterprisedb.com

Indecision is a decision. Inaction is an action. Mark Batterson

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message MichaelDBA 2022-04-26 17:59:02 Re: CTEs and temp_buffers?
Previous Message Wells Oliver 2022-04-26 17:08:31 CTEs and temp_buffers?