On 2023-05-05 21: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.
What are the cases where postgres may grow without caring about
temp_file_limit ?
thanks,
Some OSes like IIRC RHEL9 now default to tmpfs for /tmp - if your temp
files are written in a tmpfs then it may may very well trigger the OOM
because of the temp file used up all RAM.
Check the filesystem type of your temp file's location.
--
Thomas
