Le sam. 6 mai 2023 à 06:18, Adrian Klaver <adrian.kla...@aklaver.com> a écrit :
> 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> > > > > -- > Adrian Klaver > adrian.kla...@aklaver.com > >
