Re: Death postgres

Поиск
Список
Период
Сортировка
Искать
От
Peter J. Holzer
Тема
Re: Death postgres
Дата
в 07:46:25
Msg-id
20230506074625.ve4wbvt57cup63li@hjp.at
Ответ на
Death postgres (Marc Millas)
Список
Дерево обсуждения
Death postgres Marc Millas <marc.millas@mokadb.com>
Re: Death postgres "Peter J. Holzer" <hjp-pgsql@hjp.at>
Re: Death postgres Marc Millas <marc.millas@mokadb.com>
Re: Death postgres Ron <ronljohnsonjr@gmail.com>
Re: Death postgres Marc Millas <marc.millas@mokadb.com>
Re: Death postgres Ron <ronljohnsonjr@gmail.com>
Re: Death postgres Marc Millas <marc.millas@mokadb.com>
Re: Death postgres Laurenz Albe <laurenz.albe@cybertec.at>
Re: Death postgres Marc Millas <marc.millas@mokadb.com>
Re: Death postgres Laurenz Albe <laurenz.albe@cybertec.at>
Re: Death postgres "Peter J. Holzer" <hjp-pgsql@hjp.at>
Re: Death postgres Marc Millas <marc.millas@mokadb.com>
Re: Death postgres "Peter J. Holzer" <hjp-pgsql@hjp.at>
Re: Death postgres Marc Millas <marc.millas@mokadb.com>
Re: Death postgres Marc Millas <marc.millas@mokadb.com>
Re: Death postgres "Peter J. Holzer" <hjp-pgsql@hjp.at>
Re: Death postgres Marc Millas <marc.millas@mokadb.com>
Re: Death postgres "Peter J. Holzer" <hjp-pgsql@hjp.at>
Re: Death postgres Adrian Klaver <adrian.klaver@aklaver.com>
Re: Death postgres Marc Millas <marc.millas@mokadb.com>
Re: Death postgres Adrian Klaver <adrian.klaver@aklaver.com>
Re: Death postgres Marc Millas <marc.millas@mokadb.com>
Re: Death postgres Adrian Klaver <adrian.klaver@aklaver.com>
Re: Death postgres Marc Millas <marc.millas@mokadb.com>
Re: Death postgres Adrian Klaver <adrian.klaver@aklaver.com>
Re: Death postgres Thomas Guyot <tguyot@gmail.com> 
On 2023-05-06 03:14:20 +0200, Marc Millas wrote:
> postgres 14.2 on Linux redhat
> 
> temp_file_limit set around 210 GB.
> 
> a select request with 2 left join have crashed the server (oom killer) after
> the postgres disk occupation did grow from 15TB to 16 TB.

temp_file_limit limits the space a process may use on disk while the OOM
killer gets activated when the system runs out of RAM. So these seem to
be unrelated.

        hp

-- 
   _  | Peter J. Holzer    | Story must make more sense than reality.
|_|_) |                    |
| |   | hjp@hjp.at         |    -- Charles Stross, "Creative writing
__/   | http://www.hjp.at/ |       challenge!"
В списке pgsql-general по дате отправления
Предыдущее
От: Adrian Klaver
Дата:
Сообщение: Re: Death postgres
Следующее
От: Evgeny Morozov
Дата:
FAQ