Le sam. 6 mai 2023 à 09:46, Peter J. Holzer <hjp-pg...@hjp.at> a écrit :
> On 2023-05-06 03:14:20 +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. > > temp_file_limit limits the space a process may use on disk while the OOM > killer gets activated when the system runs out of RAM. So these seem to > be unrelated. > > hp > Its clear that oom killer is triggered by RAM and temp_file is a disk thing... But the sudden growth of disk space usage and RAM did happen exactly at the very same time, with only one user connected, and only one query running... > > -- > _ | Peter J. Holzer | Story must make more sense than reality. > |_|_) | | > | | | h...@hjp.at | -- Charles Stross, "Creative writing > __/ | http://www.hjp.at/ | challenge!" >