Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1pvIl5-0003SS-RG for pgsql-general@arkaria.postgresql.org; Sat, 06 May 2023 14:19:35 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1pvIl3-0003aF-Nz for pgsql-general@arkaria.postgresql.org; Sat, 06 May 2023 14:19:33 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1pvIl3-0003Xz-4e for pgsql-general@lists.postgresql.org; Sat, 06 May 2023 14:19:33 +0000 Received: from mail-yw1-x112c.google.com ([2607:f8b0:4864:20::112c]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.94.2) (envelope-from ) id 1pvIky-000rvX-8v for pgsql-general@lists.postgresql.org; Sat, 06 May 2023 14:19:31 +0000 Received: by mail-yw1-x112c.google.com with SMTP id 00721157ae682-55a20a56a01so51247077b3.3 for ; Sat, 06 May 2023 07:19:28 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20221208; t=1683382767; x=1685974767; h=in-reply-to:from:references:to:content-language:subject:user-agent :mime-version:date:message-id:from:to:cc:subject:date:message-id :reply-to; bh=vwAb6XqW6iUnkzp3EomtP9yN1I12lWDvVfRrlqVUwjU=; b=NC3MIj8BPWvMe7yJ9heQGAlAeKhD0s5X1qQg0GB9j6ujzsmKrWklbLb8Pe3xOGv8md AW11wMe/8PQSM9WgEU9pyz1g/X2WT9NmMlpkS1x7+vLxLiY3nZorNWBychcjCVUyY5BI y2igDS3LgJ4vUCZRkqrGjwIUN/VX5aXDXSwNaesG0rs/sWHX944Ov53niC92QB8JY3qc /dAcQBS6UpTEhhl4VKfX/5zJ6hfyqnBLK4lSY5ObcBO4XgcmydfNetiWgQzdj4sEzgfF qh3O/89TL4xADD8sUA4Sp2TqrYwKQvGryjXmMEEgydrVy2bz+edAzdtlCVPmogfmTjuh Kgyg== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20221208; t=1683382767; x=1685974767; h=in-reply-to:from:references:to:content-language:subject:user-agent :mime-version:date:message-id:x-gm-message-state:from:to:cc:subject :date:message-id:reply-to; bh=vwAb6XqW6iUnkzp3EomtP9yN1I12lWDvVfRrlqVUwjU=; b=T7Y2PnxAl6HnyHC1AoMOMH2O1Gf+ubQKw4J8egA69wGoHpaw3rKpZGoClfA2KpqO4M 8P24j16mvDERkq4f9Ij8pfjorIQqItiCsgCXYh7BMywm6mT3BVAUxGkwkRjbU74INbPs reUiIUFvLH8xjJr1ov/KybMmv8r0isP/6AEH6pfDQ5JhTUzzI7f2uAL70ePLDrX669TD cqRRRPVUNXotY15aX/Y3G+V5X+8GdYLZTPlp92j+62uFuDsETKLUS8u86aRs+chVs4p3 7VjcU68UTZP2y+wr7ivKQ4btzXl5rO1XKabtPM+VDra7yoNROxwbNR3Tja/j4uTPz6ky 6sIg== X-Gm-Message-State: AC+VfDxMIdcrp1Sju5sGBpwopggL/olb4okbo9Tm6ha7btxfC5JSOrkO sB/2crnTO47DRg7nB3q6/wQF2EKXEMo= X-Google-Smtp-Source: ACHHUZ6EqyEBLYMiVBP1YyRtkuyLRCiX+GZdOoA5ckSXwYmvpIgHTFgQojkVTDsd30bgJSV12eliUg== X-Received: by 2002:a81:5456:0:b0:559:e965:fee7 with SMTP id i83-20020a815456000000b00559e965fee7mr4688923ywb.41.1683382767106; Sat, 06 May 2023 07:19:27 -0700 (PDT) Received: from ?IPV6:2600:1700:bd2c:b810:9997:2896:95fb:af3b? ([2600:1700:bd2c:b810:9997:2896:95fb:af3b]) by smtp.googlemail.com with ESMTPSA id q188-20020a8180c5000000b0054f9e7fed7asm1170863ywf.137.2023.05.06.07.19.26 for (version=TLS1_3 cipher=TLS_AES_128_GCM_SHA256 bits=128/128); Sat, 06 May 2023 07:19:26 -0700 (PDT) Content-Type: multipart/alternative; boundary="------------W0vykI5PbIbIMK0zJdbhcjhq" Message-ID: <1e765391-d753-4a49-6dd2-7f99a5a55683@gmail.com> Date: Sat, 6 May 2023 09:19:24 -0500 MIME-Version: 1.0 User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:102.0) Gecko/20100101 Thunderbird/102.10.0 Subject: Re: Death postgres Content-Language: en-US To: "pgsql-general@lists.postgresql.org" References: <20230506074625.ve4wbvt57cup63li@hjp.at> <38505370-ecbd-3af3-bcff-4cf2ec4903ff@gmail.com> From: Ron In-Reply-To: List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk This is a multi-part message in MIME format. --------------W0vykI5PbIbIMK0zJdbhcjhq Content-Type: text/plain; charset=UTF-8; format=flowed Content-Transfer-Encoding: 8bit On 5/6/23 08:52, Marc Millas wrote: > > Le sam. 6 mai 2023 à 15:15, Ron a écrit : > > [snip] > > If your question is about temp_file_limit, don't distract us with OOM > issues. > > My question is how postgres can use space without caring about > temp_file_limit. The oom info is kind of hint about the context as, as > said, one select did generate both things It's a distraction to lead with "OOM killed my process".  Evidence of this fact is that all respondents have talked about is memory, not disk space. -- Born in Arizona, moved to Babylonia. --------------W0vykI5PbIbIMK0zJdbhcjhq Content-Type: text/html; charset=UTF-8 Content-Transfer-Encoding: 8bit On 5/6/23 08:52, Marc Millas wrote:

Le sam. 6 mai 2023 à 15:15, Ron <ronljohnsonjr@gmail.com> a écrit :

[snip]
If your question is about temp_file_limit, don't distract us with OOM issues.
My question is how postgres can use space without caring about temp_file_limit. The oom info is kind of hint about the context as, as said, one select did generate both things

It's a distraction to lead with "OOM killed my process".  Evidence of this fact is that all respondents have talked about is memory, not disk space.

--
Born in Arizona, moved to Babylonia.
--------------W0vykI5PbIbIMK0zJdbhcjhq--