Home > mailing lists

Death postgres - Mailing list pgsql-general

From	Marc Millas
Subject	Death postgres
Date	May 6, 2023 01:14:20
Msg-id	CADX_1aa=7vXKhsiHQA97yT1+WBcKM4PSfzvxrszC7xqnujZVVQ@mail.gmail.com Whole thread Raw
Responses	Re: Death postgres Re: Death postgres Re: Death postgres Re: Death postgres
List	pgsql-general

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.

What are the cases where postgres may grow without caring about temp_file_limit ?

thanks,

Marc MILLAS

Senior Architect

+33607850334

From: Thomas Munro
Date: 05 May 2023, 23:06:16
Subject: Re: "PANIC: could not open critical system index 2662" - twice

From: Adrian Klaver
Date: 06 May 2023, 04:17:58
Subject: Re: Death postgres