Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1uZve1-00AVk6-Ux for pgsql-general@arkaria.postgresql.org; Thu, 10 Jul 2025 18:05:17 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1uZvdz-00FlUw-U1 for pgsql-general@arkaria.postgresql.org; Thu, 10 Jul 2025 18:05:16 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1uZvdz-00FlUo-JJ for pgsql-general@lists.postgresql.org; Thu, 10 Jul 2025 18:05:16 +0000 Received: from mail-oo1-xc2b.google.com ([2607:f8b0:4864:20::c2b]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.96) (envelope-from ) id 1uZvdx-006sna-2K for pgsql-general@lists.postgresql.org; Thu, 10 Jul 2025 18:05:15 +0000 Received: by mail-oo1-xc2b.google.com with SMTP id 006d021491bc7-611a7c617b4so428276eaf.3 for ; Thu, 10 Jul 2025 11:05:13 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20230601; t=1752170712; x=1752775512; darn=lists.postgresql.org; h=cc:to:subject:message-id:date:from:in-reply-to:references :mime-version:from:to:cc:subject:date:message-id:reply-to; bh=YAUtlh8m49QUWkUOXMp5rBOxR77gXejKR+nVgNVweLY=; b=Q2vAsjaKWmS1gEhoFuR34okYRN2/TNdWFTYGocq1guMxrBq4Eeno8u4woBY4LFM3pp Wv48aAlVdL5AK3KZzw4OlVBWPnLZ7faqGz5syaxmJwoKT8s7S+aI6obcbDaX5Mi+at/4 TLPOJVdoh0ZORAmYBZjkB9ZqEVEPTHEZD3av/l8WGdC19MvIWKjR8ANIu16Rg6Hn+y0X ly9qLmf1hxRfadXgw1w2QqL/u0NYVXwqFB4jGCXWPKbQMk9lGOe892E/XHzFVamQQNVj OMgic2CQOUuroQwamxk5SDzBb2nZQaxRCqufDJn3tSfZw0veV69QmU7oT39AQeirkNUc ub7g== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1752170712; x=1752775512; h=cc:to:subject:message-id:date:from:in-reply-to:references :mime-version:x-gm-message-state:from:to:cc:subject:date:message-id :reply-to; bh=YAUtlh8m49QUWkUOXMp5rBOxR77gXejKR+nVgNVweLY=; b=wxxjMLjq/AXduUDYglCmMLn0LMf7yBCwHz2IeDlUOk6R32eAHREXJVG8w1NmPukKsJ zrp7zNscY199eaF/NkF041TieyyokW0jPiCZmNV+vbx87b16PMOp3IWGY9pB/HwSRU7j 9QRWPZteOTxLJ4zTSbVya3VVfWd41oc/qaAbZQPgkxdX1XHv9CAGfDLAE+NaqVIdz3rs 0tjGz6J98O/rs4onLZNtN/mVdxQMeIfchrVjMUbSYVqJoqOcvIFhJup9fsEK4dg0c8zq UBCPZZ5QSuU8XmMhYKd50vM4hvzucJTch5+pKdSPFR0xL5tKyDWFdp6Rb675vZLFq41z xg0A== X-Gm-Message-State: AOJu0Yz2YYICYZrHNq93g1WkceL1VngB+6E+wHHepyVtVyp2AjAwRpae NRmzCV2InAvdleWPgqxO+LZBACv0aX9KS/MePRXe8zazSHiLJQpxw8/RZAZeXwWKLDrzyhOxmIT 2sHfnPEnyYKekhvyMS0iSnfSAKWb8wZHo6YJS X-Gm-Gg: ASbGncvQ8uvGitKGYT1CBxROAe9KPBPMSlkeFWQCcKVDqM5ejB0LLXs7gheJxb8x0xx /QWtO7IGwr+MSQ5uDfK/a1hjGI+r6C3A0P3iepT36yl+Olotn1W0Q3ticokh0dfhPpmpvDxktO9 BidyyMOceHLsnclC+Z1y3vtZD+/pi+iIeFApV+Q+HrGTJsKNSi7crrpIShYenSsNnvAaODPPw7+ tY= X-Google-Smtp-Source: AGHT+IF0jLuUQcbWJ+cZrtgcp/Zgii6u5AzeGKx6C+ld8VV1vmkBZsp7/FQIwdUGvpqa6SprIJydmsBfS0GKiRu19Ig= X-Received: by 2002:a05:6870:2b01:b0:2d8:957a:5178 with SMTP id 586e51a60fabf-2ff268ddbb8mr183813fac.21.1752170711871; Thu, 10 Jul 2025 11:05:11 -0700 (PDT) MIME-Version: 1.0 References: <1de78bf7-940a-9be5-e98d-a11f02d9e898@gmx.net> In-Reply-To: <1de78bf7-940a-9be5-e98d-a11f02d9e898@gmx.net> From: "David G. Johnston" Date: Thu, 10 Jul 2025 11:04:35 -0700 X-Gm-Features: Ac12FXzD10gHO7ks8NZxW1BSvZV5IoIbv2e75WDAY6MxZkuDEe2P77dH1cvPX3A Message-ID: Subject: Re: having temp_tablespaces on less reliable storage To: Dimitrios Apostolou Cc: pgsql-general@lists.postgresql.org Content-Type: multipart/alternative; boundary="000000000000de020a0639970800" List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --000000000000de020a0639970800 Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable On Thu, Jul 10, 2025 at 10:58=E2=80=AFAM Dimitrios Apostolou wrote: > Can't find any related documentation, but I expect loss of "temp" space i= s > of minor importance. > You might want to try finding some old discussions about why putting temp tablespace on a RAM-drive is not a supported configuration. David J. --000000000000de020a0639970800 Content-Type: text/html; charset="UTF-8" Content-Transfer-Encoding: quoted-printable
On Thu, Jul 10, 2025 at 10:58=E2=80=AFAM Dimitrios Apostol= ou <jimis@gmx.net> wrote:=
Can't find any related documentatio= n, but I expect loss of "temp" space is
of minor importance.

You might want = to try finding some old discussions about why putting temp tablespace on a = RAM-drive is not a supported configuration.

Davi= d J.

--000000000000de020a0639970800--