On 5/6/23 05:25, Marc Millas wrote:
Le sam. 6 mai 2023 à 06:18, Adrian Klaver <adrian.klaver@xxxxxxxxxxx <mailto:adrian.klaver@xxxxxxxxxxx>> 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? Using psql can you \d <the_table>? Can you select from any other table in the database? -- Adrian Klaver adrian.klaver@xxxxxxxxxxx
