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(at)sqlexec(dot)com <mailto:michaelvitale(at)sqlexec(dot)com>

703-600-9343