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 1v3x30-0062K5-Kh for pgsql-hackers@arkaria.postgresql.org; Wed, 01 Oct 2025 13:39:10 +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 1v3x2y-002j7P-IN for pgsql-hackers@arkaria.postgresql.org; Wed, 01 Oct 2025 13:39: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 1v3x2y-002j7G-7x for pgsql-hackers@lists.postgresql.org; Wed, 01 Oct 2025 13:39:08 +0000 Received: from mail-ej1-x62e.google.com ([2a00:1450:4864:20::62e]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.96) (envelope-from ) id 1v3x2w-000seQ-1C for pgsql-hackers@lists.postgresql.org; Wed, 01 Oct 2025 13:39:07 +0000 Received: by mail-ej1-x62e.google.com with SMTP id a640c23a62f3a-b3d5088259eso604464466b.1 for ; Wed, 01 Oct 2025 06:39:06 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=cybertec.at; s=google; t=1759325946; x=1759930746; darn=lists.postgresql.org; h=mime-version:user-agent:content-transfer-encoding:references :in-reply-to:date:cc:to:from:subject:message-id:from:to:cc:subject :date:message-id:reply-to; bh=2p5E8EKuhgxLi26UuLUbdCJG12Q1NboEwxrSgJRGIGc=; b=kqWQqEUr4VTSvoh3mpIcAdxXOJ0Vj5JQV/uWoDkxZP6JSvdJ3mhD/8Zq6lojZJSxRe AB472o8+Yyf3KFtDVi9hhEHdvY5bgwDqdGWsDPTB7g6FshznliPYAdVOWiTe2050quqa NlmcCm4qvWmjlxq4a/YyY5qe56F9wxkAkTajQZDJGHZcnQyNhdTvgxuoo7usSVSmHhae Q2UajvmHmFOi9VCs0li3WGZv9Vksz1is+lu6i9tOfX8hLnPLF9GgSG3IQxxj+gpltw6N TDhsAuIX0UjvPakl8isdeV5x38d9dvogGrfzWdNNWa+yDofJeAvbxg0EtDfBshNT1k7t 1a/Q== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1759325946; x=1759930746; h=mime-version:user-agent:content-transfer-encoding:references :in-reply-to:date:cc:to:from:subject:message-id:x-gm-message-state :from:to:cc:subject:date:message-id:reply-to; bh=2p5E8EKuhgxLi26UuLUbdCJG12Q1NboEwxrSgJRGIGc=; b=ioYmdLtGHbeB8NJ5xPVlb9Jv+NzlWMnyqzSYPBVmcd6Eggl3GB1jA9zHHdeHG8OidL cMUOHj8Lsr0j5eV8I0PCBTDgZYIXIIX+vHJ3hlEfMv3yiyZYkJUrLTuzFUBdBO1BsjYF q5XCqawudBeP+lwLGEZXXEyikj1qUdvDU78YG+EudzyFX1q8A7xG7tYiBSwFA1HJCFlp MoakJHDwZzPy8ogK1TWdxQgpFB+PlAhYhEL49XpAAv0O0SCtpiPqmp5IyHoYqQEo+MQE eAzU2pcFM7syN00HpWrdmcRI1JsJvzTEq8Ie7AiBVyrJhqv6MVduJrGQfEUqqbtZ/pvq hPHg== X-Gm-Message-State: AOJu0Yy+Ii0H/hTGnX8UFZ3d4Svv/VkbhZApzdmQzeKDWAgCEs62AVxC Tie/32VV3GTTVjZEIGl7uuEM0EZ20C/ocZ4I+h0Nt63xG0/chLktXMbqSqQHmftcFPk= X-Gm-Gg: ASbGncv5fqDHxjxd3VMhl5ymtXLMo5dze05x3HAjMs+IrpGeLYYDWM5Bkgk2R665WYG 1YL6zarD9ktnoCdpJ1pe5GpxTo0kDWexnuODv1eJicT5LB3Mgl8OvX1CEIseyldXr8r//No/mh4 MKrqB01p4caPf0PUp5vMSwFKg8AMG3W7xO5gEnIln2uxb6zYiRKdKEcRNa93LB8JtTOjRp7iqK5 knFpm+EeDnurcvVa3ERsrA0ISWogMpPdbV8M6ETPWVOQ+Nj8C3DIXHIQFVzZm1GJvLXquuQ7eVt Mdbapv1dHNI3RPKPPdkv8TVN8m+PWIPwSpPVwYt8RygaKJpnkk623fCyOUZ137dHj84hFSPc2cb XSsWuqx3Rqdh8BkiI+j8qGoH/9oY/QxahdRtkTZiXCO7fosI= X-Google-Smtp-Source: AGHT+IGLf6sXH7iWZEQyRl0gRybsv8G9kyoNDrhHgyZ05KW+sL7KyvKFsThPR8Qp7h7BnvYHloyR1Q== X-Received: by 2002:a17:907:94d5:b0:b3e:580a:184f with SMTP id a640c23a62f3a-b46e0cb30f8mr474442766b.4.1759325945599; Wed, 01 Oct 2025 06:39:05 -0700 (PDT) Received: from laurenz.albe-K4N0CV00F97414D ([213.208.157.76]) by smtp.gmail.com with ESMTPSA id a640c23a62f3a-b3f575aa347sm613605066b.57.2025.10.01.06.39.04 (version=TLS1_3 cipher=TLS_AES_256_GCM_SHA384 bits=256/256); Wed, 01 Oct 2025 06:39:05 -0700 (PDT) Message-ID: <083a4d75ab127a603743058bce26e79ba793494e.camel@cybertec.at> Subject: Re: The ability of postgres to determine loss of files of the main fork From: Laurenz Albe To: Frits Hoogland , Aleksander Alekseev Cc: pgsql-hackers@lists.postgresql.org Date: Wed, 01 Oct 2025 15:39:04 +0200 In-Reply-To: <483AD9AA-39C1-4F4B-B0D6-4CBA0014E877@gmail.com> References: <013D63E2-5D75-492E-85FF-1D5CC0148C82@gmail.com> <45b3a1dd6be28dd409850a5503c029a97ca0754e.camel@cybertec.at> <483AD9AA-39C1-4F4B-B0D6-4CBA0014E877@gmail.com> Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable User-Agent: Evolution 3.56.2 (3.56.2-2.fc42) MIME-Version: 1.0 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk On Wed, 2025-10-01 at 13:58 +0200, Frits Hoogland wrote: > I am proposing the database to have the ability to detect when it has mis= sing segments. Just a random idea: one solution would be if each segment has a flag that i= ndicates if that is the last segment or not. But that would break the on-disk stora= ge format, unless there is room left for an extra flag somewhere in the current layout= . Yours, Laurenz Albe