Re: Death postgres
| От | Marc Millas |
|---|---|
| Тема | Re: Death postgres |
| Дата | |
| Msg-id | CADX_1aY1KtOYZaOB8F4KdHgDh7E1bbMkmNciOHc8xt2Y3=hYWg@mail.gmail.com обсуждение исходный текст |
| Ответ на | Re: Death postgres (Adrian Klaver <adrian.klaver@aklaver.com>) |
| Ответы |
Re: Death postgres
|
| Список | pgsql-general |
Le sam. 6 mai 2023 à 06:18, Adrian Klaver <adrian.klaver@aklaver.com> a écrit :
On 5/5/23 18:14, Marc Millas wrote:
> Hi,
>
> 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.
The result of EXPLAIN <the query> would be helpful.
Sure!
But. One of the table looks "inaccessible" since.
Ie. Even explain select * from the_table didnt answer and must be killed by control c
>
> What are the cases where postgres may grow without caring about
> temp_file_limit ?
>
> thanks,
>
>
>
>
> Marc MILLAS
> Senior Architect
> +33607850334
> www.mokadb.com <http://www.mokadb.com>
>
--
Adrian Klaver
adrian.klaver@aklaver.com
В списке pgsql-general по дате отправления: