Re: temporary file log lines
От
Tomas Vondra
Тема
Re: temporary file log lines
Дата
Msg-id
64634f8c-1903-3328-291e-617a80096d02@enterprisedb.com
Ответ на
Re: temporary file log lines (Guillaume Lelarge)
Список
Дерево обсуждения
temporary file log lines MichaelDBA <MichaelDBA@sqlexec.com>
Re: temporary file log lines Laurenz Albe <laurenz.albe@cybertec.at>
Re: temporary file log lines MichaelDBA <MichaelDBA@sqlexec.com>
Re: temporary file log lines Guillaume Lelarge <guillaume@lelarge.info>
Re: temporary file log lines Tomas Vondra <tomas.vondra@enterprisedb.com>
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 > 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
В списке pgsql-performance по дате отправления
От: Tobias Gierke
Дата:
