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@xxxxxxxxxxx
