On Sat, 2023-05-06 at 03:14 +0200, Marc Millas wrote: > 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 ? That's too little information for a decent answer. One obvious answer is: if it is not writing temporary files. Yours, Laurenz Albe
