| 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. |
