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 1oDVKc-0006M0-7W for pgsql-hackers@arkaria.postgresql.org; Mon, 18 Jul 2022 18:18:58 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1oDVKZ-00021T-98 for pgsql-hackers@arkaria.postgresql.org; Mon, 18 Jul 2022 18:18:55 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1oDVKY-00021K-UN for pgsql-hackers@lists.postgresql.org; Mon, 18 Jul 2022 18:18:55 +0000 Received: from mail-pj1-x1034.google.com ([2607:f8b0:4864:20::1034]) by magus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_128_GCM_SHA256:128) (Exim 4.92) (envelope-from ) id 1oDVKR-0007hi-AF for pgsql-hackers@lists.postgresql.org; Mon, 18 Jul 2022 18:18:54 +0000 Received: by mail-pj1-x1034.google.com with SMTP id g4-20020a17090a290400b001f1f2b7379dso158025pjd.0 for ; Mon, 18 Jul 2022 11:18:46 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20210112; h=date:from:to:cc:subject:message-id:references:mime-version :content-disposition:in-reply-to; bh=fCmBhfRRpTu1xiZulB8zPj6m8VHpM3gJYh/AC16wTb0=; b=BBiEi0tQDpxqOQgDQ99sS+N2+Qrhi4gwodBF0qqO/Nh7liGgewDwELmx4iBwMUef+b 0Q2ATVA/r0kfwoVBvJDHLuu8+Zt+eaYPmoqWZt1yfLwn06dyF0KM4puNjcKXlZUp7ICz /c++5aTJ072htwgo9NZVYcPD5/W1K6iTL/2AX+7AZeRgfa2Te6cYr1/ST0nvy2jX4SHS 6MOGJ+3F4NEfceDW20yR08+EkvXhy8/RQa0hFQ4BEBwi++IQGZsTzwqrJMGIqbrSs1Bv 8EC0x0K0vn+1OYYznPeOx/Td+gvZiRCmvT8GP1G/a9blD36FtTlZQs87RNwHvHVf2npq ptvg== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20210112; h=x-gm-message-state:date:from:to:cc:subject:message-id:references :mime-version:content-disposition:in-reply-to; bh=fCmBhfRRpTu1xiZulB8zPj6m8VHpM3gJYh/AC16wTb0=; b=2AB0ByuoR8TFEHnZ3dm2TrRyYc6NfH2lUoFl+4jN/Cph+lkCnqQRJrNgpjguqqm4Fb XgRZbkECeNqNPKRClQ+6DUesWZLLvuQLIwim9QLbS5/Gn6PYvaLnX+2ghxJUGKbj5chz ngF0aMuPZoIhTJhL4vwyDpmbQajrbGGUGJygC8mIohVKo0IVAvELWZtFD8h2aDxwolcZ ZLHUy9wCbxYDVwt/9lb/xWuYgORCzfiHhV77oS5BdoapXXbQe44YWQcbK3ACat0Rg5Gn q6mIKw0Ve17z2vVBZLQ8BH72ph5I56ghCIv0wZ1LZL19BZAwo4yvixmYFonznyoJq3f5 F7Fw== X-Gm-Message-State: AJIora8vpJbVOSgDEgj7pGwvdA2480wCeuOAd13BjRN4uXjqybe+bs2H T/9ww2FUniKQKOliz0CRffM= X-Google-Smtp-Source: AGRyM1sXV508VjtD7pYC0+PBmNp/ibqSVCFFPMDJ5FOfnXD1jdHjpctJBRDpOo3c994OleNixSKwow== X-Received: by 2002:a17:902:ea03:b0:16c:b3e8:b494 with SMTP id s3-20020a170902ea0300b0016cb3e8b494mr9613848plg.95.1658168324520; Mon, 18 Jul 2022 11:18:44 -0700 (PDT) Received: from nathanxps13 ([50.54.155.70]) by smtp.gmail.com with ESMTPSA id l13-20020a170903244d00b0016bfa1a5170sm8129082pls.285.2022.07.18.11.18.43 (version=TLS1_3 cipher=TLS_AES_256_GCM_SHA384 bits=256/256); Mon, 18 Jul 2022 11:18:43 -0700 (PDT) Date: Mon, 18 Jul 2022 11:18:42 -0700 From: Nathan Bossart To: Bharath Rupireddy Cc: Thomas Munro , Andres Freund , "Bossart, Nathan" , Tom Lane , Julien Rouhaud , PostgreSQL Hackers Subject: Re: Avoid erroring out when unable to remove or parse logical rewrite files to save checkpoint work Message-ID: <20220718181842.GB3642254@nathanxps13> References: <20220215181034.nyhd6fwzyg3vgxls@alap3.anarazel.de> <20220215183758.GA2435469@nathanxps13> <20220215231123.GA2584239@nathanxps13> <20220329224832.GA560657@nathanxps13> <20220330162008.GA784267@nathanxps13> <20220408201857.GA1586536@nathanxps13> <20220708171439.GB2356733@nathanxps13> MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk On Mon, Jul 18, 2022 at 04:53:18PM +0530, Bharath Rupireddy wrote: > Just wondering - do we ever have a problem if we can't remove the > snapshot or mapping file? Besides running out of disk space, there appears to be a transaction ID wraparound risk with the mappings files. -- Nathan Bossart Amazon Web Services: https://aws.amazon.com