Postgres Pro
Downloads
Home   >   mailing lists

Re: CTEs and temp_buffers? - Mailing list pgsql-admin

From Bruce Momjian
Subject Re: CTEs and temp_buffers?
Date
Msg-id YmgwZfuUCZwctrsC@momjian.us
Whole thread Raw
In response to CTEs and temp_buffers?  (Wells Oliver <wells.oliver@gmail.com>)
Responses Re: CTEs and temp_buffers?  (MichaelDBA <MichaelDBA@sqlexec.com>)
List pgsql-admin
Tree view 
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@momjian.us>        https://momjian.us
  EDB                                      https://enterprisedb.com

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

pgsql-admin by date:

Previous
From: Wells Oliver
Date:
Subject: CTEs and temp_buffers?
Next
From: MichaelDBA
Date:
Subject: Re: CTEs and temp_buffers?