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 1lPIEF-0002UI-Ig for pgsql-hackers@arkaria.postgresql.org; Thu, 25 Mar 2021 05:08:20 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1lPIEE-0008Sp-B0 for pgsql-hackers@arkaria.postgresql.org; Thu, 25 Mar 2021 05:08:18 +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 1lPIED-0008Sh-T8 for pgsql-hackers@lists.postgresql.org; Thu, 25 Mar 2021 05:08:18 +0000 Received: from mail-pg1-x52f.google.com ([2607:f8b0:4864:20::52f]) by magus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_128_GCM_SHA256:128) (Exim 4.92) (envelope-from ) id 1lPIE8-0000oC-D3 for pgsql-hackers@lists.postgresql.org; Thu, 25 Mar 2021 05:08:17 +0000 Received: by mail-pg1-x52f.google.com with SMTP id h25so636763pgm.3 for ; Wed, 24 Mar 2021 22:08:11 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20161025; h=date:message-id:to:cc:subject:from:in-reply-to:references :user-agent:mime-version:content-transfer-encoding; bh=d0vySgipTEJf0WvYOwspXNhGy139jDVbVROOSutCWbM=; b=mNMQGEiXj8XStbuVD0e08IPOPJkMk5vKAhAFLtPGAzJmrl4sn+I8wJwlNMK7MvFlXi VrlbknKM7Wj4ukGWFo3tF/CP4nohgz+5Tagfa3euvT8N6L/7ECZ8vhjj/Nk1zKEtnr/d 71St0cWeuHfPXjbXHm2B0FRcBbGWlfdAGtqf6N+EBhTUXNtJAAsKBNnqBir8pGwZ6Nhi I2BDYIt/k4K1JSCOXuuL6HrvmWofGWQOcpPI79YmNLyVCR5o8GP6h+5SU7y4dh9VKxTy 9ypfxDNMfNyhab9vJUWH9R3nABNVggDmnck6VA2bXVz1YG67NsAvvzSOE/PQiBMkns6s iZXg== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20161025; h=x-gm-message-state:date:message-id:to:cc:subject:from:in-reply-to :references:user-agent:mime-version:content-transfer-encoding; bh=d0vySgipTEJf0WvYOwspXNhGy139jDVbVROOSutCWbM=; b=BCA0dZCGkEFk19q9RQtHVbS58XNsqx+X97FeVAeFSEm9QXRVcKON2INtEhkC2ZFOqV 8CXo0dmu5V9qvxPO2MZtFt2hGAulIz09tFq9hHv7jbjKpuEaRjDgVroFuZQ2HIpC0TSH 7/DaB2KF748ewxuGoo5ET9wwGSISCQEOFJIp0XDWdBu4qYPJI5KzdVWRD9DNdV8AvsQR 7o6sJuxBnKurpauaq9LUjoG4gFzZkTeVoWZ4ozJ6/EqRvvzexPBt/G3mWSs/eTXg4GuB XK1vBApyU3MhFkQ5Kx2WLgwey6r4vd09TEZDxeO8w8BqJeWbq58QdTz8XhPOhRFQmFJp 1jFw== X-Gm-Message-State: AOAM5311GAVZcVwiTWfvqGrAVMYKVo4FWaQjShmjbUjc2wHdgOfF6hZj tkSTRAtfPyieCfu9p1XGP04= X-Google-Smtp-Source: ABdhPJykBGxo2aTbDTAQFzd5VAqbKeJAgRjrfAMVnT7mK0EFCkgsK0QDKdlgh8Sb0EQXREBzARfC6g== X-Received: by 2002:aa7:9d1c:0:b029:1f1:53b2:a5b0 with SMTP id k28-20020aa79d1c0000b02901f153b2a5b0mr5972677pfp.13.1616648890075; Wed, 24 Mar 2021 22:08:10 -0700 (PDT) Received: from localhost (KD036014041111.ppp-bb.dion.ne.jp. [36.14.41.111]) by smtp.gmail.com with ESMTPSA id e190sm4015546pfe.3.2021.03.24.22.08.06 (version=TLS1_3 cipher=TLS_CHACHA20_POLY1305_SHA256 bits=256/256); Wed, 24 Mar 2021 22:08:09 -0700 (PDT) Date: Thu, 25 Mar 2021 14:08:05 +0900 (JST) Message-Id: <20210325.140805.1356865766630580851.horikyota.ntt@gmail.com> To: tsunakawa.takay@fujitsu.com Cc: osumi.takamichi@fujitsu.com, sfrost@snowman.net, masao.fujii@oss.nttdata.com, ashutosh.bapat.oss@gmail.com, pgsql-hackers@lists.postgresql.org Subject: Re: In-placre persistance change of a relation From: Kyotaro Horiguchi In-Reply-To: <20210114.173217.1012910300445215120.horikyota.ntt@gmail.com> References: <20210108.175221.1020658670277126419.horikyota.ntt@gmail.com> <20210112.185808.926258436521829536.horikyota.ntt@gmail.com> <20210114.173217.1012910300445215120.horikyota.ntt@gmail.com> User-Agent: Mew version 6.8 on Emacs 26.1 Mime-Version: 1.0 Content-Type: Multipart/Mixed; boundary="--Next_Part(Thu_Mar_25_14_08_05_2021_730)--" Content-Transfer-Encoding: 7bit List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk ----Next_Part(Thu_Mar_25_14_08_05_2021_730)-- Content-Type: Text/Plain; charset=us-ascii Content-Transfer-Encoding: 7bit (I'm not sure when the subject was broken..) At Thu, 14 Jan 2021 17:32:17 +0900 (JST), Kyotaro Horiguchi wrote in > Commit bea449c635 conflicts with this on the change of the definition > of DropRelFileNodeBuffers. The change simplified this patch by a bit:p In this version, I got rid of the "CLEANUP FORK"s, and added a new system "Smgr marks". The mark files have the name of the corresponding fork file followed by ".u" (which means Uncommitted.). "Uncommited"-marked main fork means the same as the CLEANUP2_FORKNUM and uncommitted-marked init fork means the same as the CLEANUP_FORKNUM in the previous version.x I noticed that the previous version of the patch still leaves an orphan main fork file after "BEGIN; CREATE TABLE x; ROLLBACK; (crash before checkpoint)" since the "mark" file (or CLEANUP2_FORKNUM) is revmoed at rollback. In this version the responsibility to remove the mark files is moved to SyncPostCheckpoint, where main fork files are actually removed. regards. -- Kyotaro Horiguchi NTT Open Source Software Center ----Next_Part(Thu_Mar_25_14_08_05_2021_730)-- Content-Type: Text/X-Patch; charset=us-ascii Content-Transfer-Encoding: 7bit Content-Disposition: inline; filename="v6-0001-In-place-table-persistence-change.patch"