Re: CTEs and temp_buffers?

Hmmm, I think you may be wrong about that one, Bruce.  I tried that before and log_temp_files seems to only log work_mem errors, not temp_buffers associated with temporary table allocations. The only way to see temp files used by temporary tables is to monitor the   <datadir>/base/pgsql_tmp directory, and that can be quite tricky since it happens so fast there.

Regards,
Michael Vitale


Bruce Momjian wrote on 4/26/2022 1:48 PM:

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.

Regards,

Michael Vitale, Sr. PostgreSQL DBA

Michaeldba@sqlexec.com

703-600-9343