Le sam. 6 mai 2023 à 06:18, Adrian Klaver <adrian.klaver@xxxxxxxxxxx> 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@xxxxxxxxxxx
