Re: Death postgres

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?

Using psql can you \d <the_table>?

Can you select from any other table in the database?





-- 
Adrian Klaver
adrian.klaver@aklaver.com