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 1uZvY7-00ASYE-GE for pgsql-general@arkaria.postgresql.org; Thu, 10 Jul 2025 17:59:11 +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 1uZvX6-00FgTY-K6 for pgsql-general@arkaria.postgresql.org; Thu, 10 Jul 2025 17:58:09 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1uZvX6-00FgTO-9N for pgsql-general@lists.postgresql.org; Thu, 10 Jul 2025 17:58:08 +0000 Received: from mout.gmx.net ([212.227.17.21]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.96) (envelope-from ) id 1uZvX4-006c6c-2l for pgsql-general@lists.postgresql.org; Thu, 10 Jul 2025 17:58:08 +0000 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmx.net; s=s31663417; t=1752170284; x=1752775084; i=jimis@gmx.net; bh=vHlzB2N2UBtDM+G9vpRUyf4EjKhvdXntsOwmWy3b6Go=; h=X-UI-Sender-Class:Date:From:To:Subject:Message-ID:MIME-Version: Content-Type:Content-Transfer-Encoding:cc: content-transfer-encoding:content-type:date:from:message-id: mime-version:reply-to:subject:to; b=VTu/PEWRRErN2poGOH5llVxaTnH1EElJm5BlOzxJKPrX3LBUemZ3i3A2AKfCTXg5 yuQupqrX1a1UY1qfEL00/yeTfjb4zHrMKwd5RkOFHUrUB79oKCJbeaw1LKtgoo4u2 T7+qRbdGhHI+KQmzBlKs0demvgDlAL0mIfhcp+fzuzGJl+daOIk+aGJlJXjEUaMfJ sS0f5uvWAOTMdWAX49iTqYAXKEurAzFhpLYJeS4H4JumGx9Cp8Z0JAWwVnn0soRUy 4v4W4P0gRX7p/wRGffw1d4vYQokrUsDsjUV3Q4jpeJ7EVvzfRFMoBjDJ6JBu8UzHx LJGO3f787OP7uX2mJg== X-UI-Sender-Class: 724b4f7f-cbec-4199-ad4e-598c01a50d3a Received: from [10.9.70.81] ([185.55.106.54]) by mail.gmx.net (mrgmx104 [212.227.17.168]) with ESMTPSA (Nemesis) id 1MnJhU-1uz38K1pem-00ZCOb for ; Thu, 10 Jul 2025 19:58:04 +0200 Date: Thu, 10 Jul 2025 19:58:03 +0200 (CEST) From: Dimitrios Apostolou To: pgsql-general@lists.postgresql.org Subject: having temp_tablespaces on less reliable storage Message-ID: <1de78bf7-940a-9be5-e98d-a11f02d9e898@gmx.net> MIME-Version: 1.0 Content-Type: text/plain; format=flowed; charset=US-ASCII X-Provags-ID: V03:K1:unMUo4hYpsXI5kexXPt9W62WWDGPIAtYBz4TpQeOYZ2GPP7yDbr U/ucd7MZNpbpIS8GruS8RfCM9d3du+b/RnFcQ4PPvbZRcRDnbRON4zjWSkV2qFXeg7oH2kA hkcxJJ8sjZcy5tSSXn6dyWYzrpAeoAq2gDctjASTrcx3i0MhOuyhiJ/epVHC7x740EsYIYt HNHXIqjDkUoPZx0McasFQ== X-Spam-Flag: NO UI-OutboundReport: notjunk:1;M01:P0:RmzWWkbpWPE=;y/I/9jA3Ji+W0d0aGGcLQD2gnA8 2pprarV23pbRO70e+CVzScXGQ+eRxoBv5vi3V6gFu5yXxb0TWM+07A34ccN6wIvK3GWptROTx 0rscUQ3VqQ/UBIip0QFTdb4hs9bqp6R0Pip3mWZqVZCJizYsXZrNqhlZFNIa+O0nCl54Wsu7G dpSTXRuLEqvHMbRJBDgLDFgJIKpcXnKuGRnfh4ZY0yT3WAcW45mciey9lDlbTry6hQVN7xzjH 5zqa0yYwNPUjRD8Arj5IeLcwNNZ9JYU3Sa/tkJoaSwY8mii3fRXqoroN2uyDV3i9O1g4Dd6Ey To6+xkvrjK2i7nNs7wkbu9avhTn+VvqWjKeAuZ+n1ZJ0T27vT9Z8QteLKUQWC75skfa557pRk k1yqTwEC/yxtfcLWPWGDUM+3U0scIADkyAcyWtmX7Os/zO8ivIJQIiK6gPH5zW0ZhavZSpYhl rD7mu7hr55eeukDAlIFGhzEiGEbVrjeW7BES9FXjrHHRqdHFNyYFEcQzQhETHlM0pGxRKCo/R /K+mcoMncy8eI4AN+/NspwfNwussx1zXclT4snUQFwncAmsqO5GHS6ATHFDzVbQLai93Ly8xx Ok0+WSRDqXm1NkZkloOccU80V/byhcx8JPZu9zarwgtj/saEJvOSvanI5parNW6jjngqkjVra WU5bUcxXLDoQF3V2QSjnKH0bTK8XquoLAoTFD0Da+PkxnBGTCAica0YMtv+bB0SupLcS5umpM hwigbDk1YW2mDZVzlMfBOgSinv2+GZTkE+oYTMH7kybpMbngdWKRVmdBiRHFp8oQurDOXGiZz Eqshf7IQWc4PUxM5qyXphHewUUEcBUSL9yuwxPtqSD89psVzArAmc6i8jNFDWz3WFyP2RSUko wa239xaX+JG/3gsw+2DnnR1QJmrlEbpOaSplaQJOW40QLI5u8UIbkpEqEBF3TVzl3aNTmSGJ9 GswbWFG3nH5BoIANIefdcd2+OD7jrhRqBojIk+FKJJl3cNZXd7r+vGJSAiFLLw50xNZVo0PXG iR4fZHV0siwntoWs/gwUjzj06p3LAau9vl4OFyPp/UGw+6yWivC18rI1KesNn4Bh9yVaKbVyx H0klMnk5QKOJssJFY0crU7fShuw2veiEf7P8kS9eRoKFDZ4lMroCvfFDCUQzOSMjEt6cOu871 XcgubvggG6B8TukQ2/sJ4dVjO9+i6uZp8ufScoMcwZGYJWs9WFehkjnLtBcSFdNybA6aNMg+c v9aAEVUXCCu+Ngs6dWdZXji31mLGFzVPw9YDMrPUZkb+S5kDqBW40rc/V7X+E9KOxMHRqTRc2 TRCNfva0K84dXBBXRsr7sOIRfCRnYqfXB2mqrdu0Nf+nktXRL2zvGrCWXUHozji51W/eurbxp FHkDcuCG05xi6jz6pFGLRFAgh+zRIjG1Ro5wnrHhu592RNdUnD7nUwZ1T4aCClX9YxaXNd8ah ZspwxMBkC4tIy4P/3l/K+DuywzsWABKeo1gqN0pwfnDOttIib/PkbAPkIKfDSaLJy7+XtRU3/ aCXcX0KFD0wZS1MATOzEAJ+07mZ/Jt4kta8nygc+lnuCkAxYhRm3eHmfMYLY/RubNP+xTIhDA LyTZ0sOfv3eot2lC0f0D1cUbPiLAZ4fCAsTgNLZKEd4SCTYMUw0eQiAnPBN+Z1eSgHVnY5fH2 tKf6q2STUvyoDthvpI+GR8dv2gC69nKJrz/5jevxenv59/y0AUVs1Q3wpBXxEzaeBNG45YpoA Yy1tWWj+pbrLUNTr0RoY/Ujs/clQP9+T1yYRyBztJap5AS8znpxnP3e1/2Lt8ayzEl5j33Zf3 poszLJ5IKBb62t/B23jOplx32rVsU1lf73QLM8x2OusjBBAtCr/u5BjoibuJXR89ArJjffONl DezeNy7wH+QKkjtb1ZOMoTPk9Sng/5WxvwNmkSk2jRsdrbwuihStAkuMiRv4RT9X2OcuSeTBs zinfLko1L27GsQCmSxDyTd26ZCWwQD2uX5wchUAL53UFHVn0evzmTGATdu1Q9CMitX+AT/wCA ncA46uX7P3uiYi6QyETECgIMVj7hT4ioF9CGY6J/iL28GdD6aYMAEhe0iS/JZRC0aU9sWB0Fz jPKZE/7ejVipkuxkXb7J9+RZG0VNrQHSQMpuQ4YFs7GIiJNyXqnDKnNoZWqQ015MGVJV67MJZ CFf+wY2wiiQv1PiG+853UjQW/3A3LN17BIh0gQgW8dlWEaFFuzRsZyh0WPz2UUuEGGWsg0zYP ePJeCaLQAcE6EbVPTgGfaJS5XFLiLcKubfzowHpDHe018e++YnvW3AgO4NfmEEI8pfHr9T6/X 2l2Aq4nwFDTf0Cc47yl8+O8quutvktZC3vS8NICv9B2mg4G4rrfidfqXMBRpRe//+hJi/U/SV ECs8PttPH0uXx3oJhUNjHtHaPMdIjWnitakJ0EKcn52BEnr4MHAy3YdCXWAaRqjxA4nR3QQKF FjO/BeUyRLYNGxjbbmjTtIysm7qJebMdBS+KvusI5wQgUYN+R4OzUrAj/gl1WdgDvW6hc7Wzh SoYFHQyFNvO5n70qaTigzzxGhz5EzHhJDCtgiCyjg6uoU7Nv04mWAwkZafIWI+152GA7N2U+b cE1hqjnPv8DeKKwDFNdLmLI9phfvQSh6X61nKUrJFVB8Qu4hy6lH4FkyuETdnIqBkPbaDWQib WTKA4g6CQRRjryLgU7WjGEH46NHlVnQ7fEHV5YX3NUIbvTd5zEWqnn5Q9DU9Me3n9bHMuN45d zeLinPOP+6nB+U+590bYKRh32v1xyousrPqRbaEA5d/v9woovcJdL8dYCsR1IVKqKBovIJtjL pWATiOoYK2TZ8nFd0CYPvaHIgAPIdKPaH1ciHKj8XVTnxTzSNzPEwEx0evmMO52kdDdf1Uulh lAH4TI/I90KZRvpmdZBXkxZ5pKpGyzJJqDnV9oG+PTOIk9LvC15zL1fl6+i551fZWkaBtS6db 0on48aJ+/45euH08KI0Vsq/wmSqj5GMdP78Wy6IiuzUV5dFJK+MqleafslyiF7DXNySTI8MeX wTDwp28aQN5fOXrLbjqE05xLjcTNyzpKRcvzX4FoVfUB8vRNQDtCBPJyFeEqUhaKmH2iDtaN1 leX3Rh+Y+IhWQk6ur8g8KB8EB6wS7wyiNALfFLcndoEUBbv/jUlvu2ZkdOlmE9Y3840FMNJSt pw6X0rbOYfpKi3ApH02ZAFzI1QFSjYRKX9spGsDLq+D7u+wkDVNxB4OcjZ/lTY/V/icLUvjag 2XN6ijOkzmHSdLZxCx96iwLiAvjcVT+89P271V14eULnoAnrIfiubOnOcaJb5Ln/omcf7LL4o MuxOEk9cpw5s0au1rC/LSb6CZaCy6bgWIu+33HBrHMkgali8EiILM2Of/+CvbDkK36pX+RK Content-Transfer-Encoding: quoted-printable List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk Hello list, I have a database split across many tablespaces, with temp_tablespaces=20 pointing to a separate, less reliable device (single local NVMe drive).=20 How dangerous is it for the cluster to be unrecoverable after a crash? If the drive goes down and the database can't read/write to=20 temp_tablespaces, what will happen? If I then configure temp_tablespaces to point to a working location, would= =20 that be enough to start the cluster? Or other bad things can happen? Can't find any related documentation, but I expect loss of "temp" space is= =20 of minor importance. Thanks in advance, Dimitris