From: Tomas Vondra <tomas.vondra@enterprisedb.com>
To: Guillaume Lelarge <guillaume@lelarge.info>
To: MichaelDBA <MichaelDBA@sqlexec.com>
Cc: Laurenz Albe <laurenz.albe@cybertec.at>
Cc: PostgreSQL Performance <pgsql-performance@postgresql.org>
Subject: Re: temporary file log lines
Date: Tue, 13 Jul 2021 20:01:23 +0200
Message-ID: <64634f8c-1903-3328-291e-617a80096d02@enterprisedb.com> (raw)
In-Reply-To: <CAECtzeW79YKKXV207wZUnQYZxh7Nc7G1JajnDgCFfznrD03n4A@mail.gmail.com>
References: <d658f01b-7a1d-da5e-e996-3403e6b7cf49@sqlexec.com>
<4827fef49e0d0410eedca61e235a16efc1d835de.camel@cybertec.at>
<ce8f3920-764e-a495-1bab-8b0bf22d671e@sqlexec.com>
<CAECtzeW79YKKXV207wZUnQYZxh7Nc7G1JajnDgCFfznrD03n4A@mail.gmail.com>
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: tomas.vondra@enterprisedb.com, guillaume@lelarge.info, MichaelDBA@sqlexec.com, laurenz.albe@cybertec.at
Subject: Re: temporary file log lines
In-Reply-To: <64634f8c-1903-3328-291e-617a80096d02@enterprisedb.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox