On 5/6/23 05:25, Marc Millas wrote: > > > Le sam. 6 mai 2023 à 06:18, Adrian Klaver <adrian.klaver@aklaver.com > <mailto:adrian.klaver@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?