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.
>
> 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