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 1ltoCf-0003IZ-8T for pgsql-hackers@arkaria.postgresql.org; Thu, 17 Jun 2021 09:20:49 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1ltoCe-0002ik-0V for pgsql-hackers@arkaria.postgresql.org; Thu, 17 Jun 2021 09:20:48 +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 1ltoCd-0002ic-M0 for pgsql-hackers@lists.postgresql.org; Thu, 17 Jun 2021 09:20:47 +0000 Received: from meesny.iki.fi ([2001:67c:2b0:1c1::201]) by magus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1ltoCX-0001sg-ML for pgsql-hackers@lists.postgresql.org; Thu, 17 Jun 2021 09:20:47 +0000 Received: from [192.168.1.113] (dsl-hkibng22-54faa4-119.dhcp.inet.fi [84.250.164.119]) (using TLSv1.3 with cipher TLS_AES_128_GCM_SHA256 (128/128 bits) key-exchange X25519 server-signature RSA-PSS (2048 bits) server-digest SHA256) (No client certificate requested) (Authenticated sender: hlinnaka) by meesny.iki.fi (Postfix) with ESMTPSA id 7BD6F20191; Thu, 17 Jun 2021 12:20:39 +0300 (EEST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=iki.fi; s=meesny; t=1623921639; h=from:from:reply-to:subject:subject:date:date:message-id:message-id: to:to:cc:cc:mime-version:mime-version:content-type:content-type: content-transfer-encoding:content-transfer-encoding: in-reply-to:in-reply-to:references:references; bh=Lj/JGC+7y+Dgq5MlTISCkjADAg8HhbKNYg7EVEKTzNU=; b=xRw1J7WOXDsds31WFu2ITlGcM2aPZPWEJpg1xAa3i4snLHEJnbHWNdWjIpkMQR2cdNZoo8 sQaowssRyKCAkxQ6w62sdFunzgrHY4rtbm8mFYW8yUbfOsDoM3DjzC/3Oss1tyeHGguajG gbc4nvQ/HXYYqh1c5TXEZLR81koZ5dM= Subject: Re: [Proposal] Fully WAL logged CREATE DATABASE - No Checkpoints To: Dilip Kumar , Andres Freund Cc: PostgreSQL Hackers References: <20210616215804.nhc7bpkuoscfrv52@alap3.anarazel.de> From: Heikki Linnakangas Message-ID: <9dba95df-982e-da50-c8f3-7601fbfbda29@iki.fi> Date: Thu, 17 Jun 2021 12:20:39 +0300 User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:78.0) Gecko/20100101 Thunderbird/78.10.0 MIME-Version: 1.0 In-Reply-To: Content-Type: text/plain; charset=utf-8; format=flowed Content-Language: en-US Content-Transfer-Encoding: 7bit ARC-Authentication-Results: i=1; ORIGINATING; auth=pass smtp.auth=hlinnaka smtp.mailfrom=hlinnaka@iki.fi ARC-Seal: i=1; s=meesny; d=iki.fi; t=1623921639; a=rsa-sha256; cv=none; b=V7OLDqSIt2I4a3YGNs3v5P/35Rlbas5q0KBbrODki6GhvDzM++t63Uw+cHkHFusxgLKvcS A+trH+a1oaCXHMfvx5ojw1wmPy5CqOmvBLYRMAfgNcXkA5YPZBzJEU4meQJa9tmHjvPTpE v266a2N3Bj/wgWH2OLUFfW93Jhuk+8E= ARC-Message-Signature: i=1; a=rsa-sha256; c=relaxed/relaxed; d=iki.fi; s=meesny; t=1623921639; h=from:from:reply-to:subject:subject:date:date:message-id:message-id: to:to:cc:cc:mime-version:mime-version:content-type:content-type: content-transfer-encoding:content-transfer-encoding: in-reply-to:in-reply-to:references:references; bh=Lj/JGC+7y+Dgq5MlTISCkjADAg8HhbKNYg7EVEKTzNU=; b=VJBQpDgt2Cph9HKyTqFBRsh85xkSi1471Sy28Zzt0fSAuSiBZbspASA/fEZJJ66VgHPuJw HrU/YEPL3uhcNhD0qAo4NonlVThdzH6BzweFKytTFupTcLBO38bhMQOfB+hElIiXHntUng /vwVbkexKaHc9ksB2N+dF5ohwL59wkA= List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk On 17/06/2021 08:45, Dilip Kumar wrote: > Another problem with directly scanning the directory is, how we > are supposed to get the "relpersistence" which is stored in pg_class > tuple right? You only need relpersistence if you want to use the buffer cache, right? I think that's a good argument for not using it. - Heikki