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 1v3vHp-005esG-Im for pgsql-hackers@arkaria.postgresql.org; Wed, 01 Oct 2025 11:46:21 +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 1v3vHm-001EOX-5D for pgsql-hackers@arkaria.postgresql.org; Wed, 01 Oct 2025 11:46:18 +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 1v3vHl-001EOP-Q0 for pgsql-hackers@lists.postgresql.org; Wed, 01 Oct 2025 11:46:18 +0000 Received: from mail-oo1-xc2c.google.com ([2607:f8b0:4864:20::c2c]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.96) (envelope-from ) id 1v3vHg-0014bz-34 for pgsql-hackers@lists.postgresql.org; Wed, 01 Oct 2025 11:46:17 +0000 Received: by mail-oo1-xc2c.google.com with SMTP id 006d021491bc7-64a12d970ccso962220eaf.3 for ; Wed, 01 Oct 2025 04:46:12 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=tigerdata.com; s=google; t=1759319171; x=1759923971; 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=YoGgjvWpvcNkh4r//CvWHjU9fwVaAyUVyZsycjT6D4s=; b=JcJ4Am6lTqiKI3jBXVJ4c/9/3iCfpdGk6xglnsnCNtpNcF2T3c3mcvgYv/X9f0yJo7 dMsOGtU31eP7OC13RpFG8Rv42TcTMbixsPV0KywbdySuv1EtSSolDO/D/h7tKUl6Gq5I 6n4UZgzLlIyH7TlbyI+P4vssk1lHXZSl4abWINuCrLXg9/w3y/UaXcvBCOGKcqx0F0l5 RcSKXkmOJUfl/bJBgC2POWAWnqegDQywto7wmt5pAEGldhDDfs4L++AV3LnyxNYi0n92 rI89dbs7LyI/Y38LQXnMlL6OBs1rImMyH+bKEoPhil56fOwIh7hsUZ278Nen+1I5Lkix eNLQ== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1759319171; x=1759923971; 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=YoGgjvWpvcNkh4r//CvWHjU9fwVaAyUVyZsycjT6D4s=; b=gZYls1D/f1GTQvEpj100cQEcstivQLdNEoBFWP+ybZn1n0NBe+DPpT+RjeY3aYC+2C AZmn18jKAon3huIHpJSFohCcfRTypNBLx8iKnCbs1gn6lTO+ntmKsOuRlNpSH47q6FcV as3V9K4w4830TowdaKtTh2aMJ/ARCtxcKWykjbiPtEM/xrdEO4kNKdKocZyFnoxtes+3 QhaY2NigliXTbwMXWhg5zy1ZxaTvaoqE77Wq8ik50e9OvONIqK/ypS4bBQ5kaMCB8Z8S KFYAZiKwGevgQSnQ9KXnhA2RB/ak8GCRfpdRL/oMIkz3jr7S2yFcDq81ek7rAcPxmnuS hQ6A== X-Gm-Message-State: AOJu0YxAVq3QY3bmyg2mOG77ZB1f7nbG7hs9a0TOIgsaZk13vE8OPiUg gq9YaycBSqx2mhq3Wkiv57NN/I4SGKVJW3wls1G0jx74Zch2SAArgAyAEcZDyriOkwBni7OKtj5 m13cuNl8UcD79edMvd+DWSRwmUbcUF2mw5oXi7AtvjBLl8v3iRgdGJ2c= X-Gm-Gg: ASbGnctL6kMYpa26t2lOHfYj2o1avRV6KpDc+xUGJAfhG48XUp/Pxe20+gPuBFxDQN0 OnYJ5CfbZEyxqWgFWvikj07NUobcx+OvCtL2vlhkoSiO4VCYnqwKOWaSn2VwKx/qi6hwsoQqVRN EiZaU+FsAKZQx974Q3yT5anpGPg7Xbc/oaLTN93j91biC3Tl6AAJmLZxvba49kG8Xoy7PcMwHZZ 21bJKiB6XyAG7+hoqnX3Pypk5ISpw== X-Google-Smtp-Source: AGHT+IFr19uxoUdgzuHED/s9ZIaWm65Jav6V1oAe8em0e/tTkneB0r5jpzPrNuSUm9sU1ujlRU06n+E3Ir88v0tqa+4= X-Received: by 2002:a05:6820:4df1:b0:63c:4eb8:1746 with SMTP id 006d021491bc7-64bc1002188mr1536293eaf.8.1759319170797; Wed, 01 Oct 2025 04:46:10 -0700 (PDT) MIME-Version: 1.0 References: <013D63E2-5D75-492E-85FF-1D5CC0148C82@gmail.com> <499686.1759250489@sss.pgh.pa.us> <68dcd1f2.df0a0220.3300c0.f7af@mx.google.com> In-Reply-To: From: Aleksander Alekseev Date: Wed, 1 Oct 2025 14:45:59 +0300 X-Gm-Features: AS18NWCw-urhuUIS8ZtiYXGaUtsrvEJNvueTpERH5g14i4XNGcocN5meIxbyepA Message-ID: Subject: Re: The ability of postgres to determine loss of files of the main fork To: pgsql-hackers@lists.postgresql.org Cc: Jakub Wartak , Michael Banck , Tom Lane , Frits Hoogland Content-Type: text/plain; charset="UTF-8" List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk Hi Jakub, > IMHO all files should be opened at least on startup to check integrity, That might be a lot of files to open. Even if you can open a file it doesn't mean it's not empty or is not corrupted. -- Best regards, Aleksander Alekseev