Le sam. 6 mai 2023 à 18:11, Adrian Klaver <adrian.kla...@aklaver.com> a écrit :
> On 5/6/23 05:25, Marc Millas wrote: > > > > > > Le sam. 6 mai 2023 à 06:18, Adrian Klaver <adrian.kla...@aklaver.com > > <mailto: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 > > When you restarted the server where there any warnings shown? > Sadly, I cannot. Will be done next tuesday. > > Using psql can you \d <the_table>? > Yes, and no pb to check pg_statistic,... > > Can you select from any other table in the database? > Yes > > > > > > -- > Adrian Klaver > adrian.kla...@aklaver.com > >
