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