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.
What are the cases where postgres may grow without caring about temp_file_limit ?thanks, Marc MILLAS Senior Architect +33607850334 www.mokadb.com <http://www.mokadb.com>
-- Adrian Klaver [email protected]
