Subject: Re: temporary file log lines
To: Guillaume Lelarge <guillaume@lelarge.info>,
 MichaelDBA <MichaelDBA@sqlexec.com>
Cc: Laurenz Albe <laurenz.albe@cybertec.at>,
 PostgreSQL Performance <pgsql-performance@postgresql.org>
References: <d658f01b-7a1d-da5e-e996-3403e6b7cf49@sqlexec.com>
 <4827fef49e0d0410eedca61e235a16efc1d835de.camel@cybertec.at>
 <ce8f3920-764e-a495-1bab-8b0bf22d671e@sqlexec.com>
 <CAECtzeW79YKKXV207wZUnQYZxh7Nc7G1JajnDgCFfznrD03n4A@mail.gmail.com>
From: Tomas Vondra <tomas.vondra@enterprisedb.com>
Message-ID: <64634f8c-1903-3328-291e-617a80096d02@enterprisedb.com>
Date: Tue, 13 Jul 2021 20:01:23 +0200
User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:78.0) Gecko/20100101
 Thunderbird/78.11.0
MIME-Version: 1.0
In-Reply-To: 
 <CAECtzeW79YKKXV207wZUnQYZxh7Nc7G1JajnDgCFfznrD03n4A@mail.gmail.com>
Content-Type: text/plain; charset=utf-8; format=flowed
Content-Language: en-US
Content-Transfer-Encoding: 8bit
Archived-At: 
 <https://www.postgresql.org/message-id/64634f8c-1903-3328-291e-617a80096d02%40enterprisedb.com>
Precedence: bulk


On 7/13/21 9:29 AM, Guillaume Lelarge wrote:
> Hi,
> 
> Le lun. 12 juil. 2021 à 14:13, MichaelDBA <MichaelDBA@sqlexec.com 
> <mailto:MichaelDBA@sqlexec.com>> 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 temporary tables, just queries as you mentioned
>     below elsewhere.  This seems to be a dark area of PG that is not
>     convered well.
> 
> 
> As far as I know, log_temp_files only relates to sort/hash going to 
> disks, not to temporary objects (tables and indexes).
> 

Right. log_temp_files does not cover temporary tables.


regards

-- 
Tomas Vondra
EnterpriseDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company