Re: temporary file log lines

On 7/13/21 9:29 AM, Guillaume Lelarge wrote: Hi, Le lun. 12 juil. 2021 à 14:13, MichaelDBA > a écrit : hmmm, I think spilling over to disk for temporary tables is handled by an entirely different branch in the PG source code.  In fact, some other

Re: temporary file log lines

Hi, Le lun. 12 juil. 2021 à 14:13, MichaelDBA a écrit : > hmmm, I think spilling over to disk for temporary tables is handled by > an entirely different branch in the PG source code. In fact, some other > folks have chimed in and said log_temp_files doesn't relate to temp > files at all use by

Re: temporary file log lines

hmmm, I think spilling over to disk for temporary tables is handled by an entirely different branch in the PG source code.  In fact, some other folks have chimed in and said log_temp_files doesn't relate to temp files at all use by temporary tables, just queries as you mentioned below elsewhere

Re: temporary file log lines

On Thu, 2021-07-08 at 17:22 -0400, MichaelDBA wrote: > I got a question about PG log lines with temporary file info like this: > > case 1: log line with no contextual info > 2021-07-07 20:28:15 UTC:10.100.11.95(50274):myapp@mydb:[35200]:LOG: > temporary file: path "base/pgsql_tmp/pgsql_tmp35200.0

temporary file log lines

Hi all, I got a question about PG log lines with temporary file info like this: case 1: log line with no contextual info 2021-07-07 20:28:15 UTC:10.100.11.95(50274):myapp@mydb:[35200]:LOG: temporary file: path "base/pgsql_tmp/pgsql_tmp35200.0", size 389390336 case 2: log line with contextual