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. Sure!
But. One of the table looks "inaccessible" since.
Ie. Even explain select * from the_table didnt answer and must be killed by control c
> > 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> >