Death postgres

[Marc Millas <marc.millas@xxxxxxxxxx>]

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,

Marc MILLAS

Senior Architect

+33607850334

www.mokadb.com