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 1sV8FK-0085bk-UH for pgsql-hackers@arkaria.postgresql.org; Sat, 20 Jul 2024 11:27:26 +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 1sV8FI-00F2ir-TN for pgsql-hackers@arkaria.postgresql.org; Sat, 20 Jul 2024 11:27:25 +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 1sV8FI-00F2if-Cb for pgsql-hackers@lists.postgresql.org; Sat, 20 Jul 2024 11:27:25 +0000 Received: from mail-pg1-x52d.google.com ([2607:f8b0:4864:20::52d]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.94.2) (envelope-from ) id 1sV8FG-000Wgf-Eo for pgsql-hackers@lists.postgresql.org; Sat, 20 Jul 2024 11:27:23 +0000 Received: by mail-pg1-x52d.google.com with SMTP id 41be03b00d2f7-767506e1136so1956861a12.0 for ; Sat, 20 Jul 2024 04:27:22 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=leadboat.com; s=google; t=1721474841; x=1722079641; darn=lists.postgresql.org; h=user-agent:in-reply-to:content-disposition:mime-version:references :message-id:subject:cc:to:from:date:from:to:cc:subject:date :message-id:reply-to; bh=rEBKgYK+BsHSwRXTlgkekpyZUuqUzAhvW828ODJFNHk=; b=NM+gFEjwFEMHl+wYyLwhuca3qioK0i7123upgsBffafawQmUHVgOV3ZcFs9slXT3D6 MzUAP6VuQBdVTods08gPpQ3D4PQOngmIqgxpJ/n69fNakpieoQ1dcETFyugj8I9DwEBQ hjAEH1EAZsKxmQnOMGwf/BmnG/xuzgpkXtQCI= X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1721474841; x=1722079641; h=user-agent:in-reply-to:content-disposition:mime-version:references :message-id:subject:cc:to:from:date:x-gm-message-state:from:to:cc :subject:date:message-id:reply-to; bh=rEBKgYK+BsHSwRXTlgkekpyZUuqUzAhvW828ODJFNHk=; b=VTmFwmndZpWAzcy1z9VKJMwLq19giFCOtUpabNz/nGPB+CMiKWZFEPxOX9ruguQ+G6 qrj40rvYI+28xEp4f/1x2x1BQaTxydaBp7MXKgcidkcPZ/JNMr3cOlDhhk28xuT7+SAM k4iOeODB9divFasEurkd/CFbSuu/zcnEC5NiGDquYt6zxIqYFlOITT3EBNVWsIHanPk+ tm8md3Q83sY3bkTaAaLgtEA5vT22xdduGBBDsEYpxG6o6yZ/0ZAuWXbq5rBPF6eyf1Vz YOzS11+wAWtCZ7C19rI4kxsPIKDd6hoAgQc18cJmjy2MqPY7O2bPQdihDbiI7F5R7dqd wGEA== X-Gm-Message-State: AOJu0YzTjicvVh3GiSQiaz9Oqaev6ehUJss1dosNU7jLgy7+EsAmRWP+ 9x4RXXH/eebOP9FxWGYPPq/WW1uqfYLUPqrdi8fKzfmDF1hQXq3MXk0YKnfNmQ== X-Google-Smtp-Source: AGHT+IHk75HMNM7jrLvZVId9EMQAHyO/Bwz/JA5wQh2/lwsCTqcIkMbPcEWALGU1Wp6ezmaSit1xpQ== X-Received: by 2002:a17:90b:70a:b0:2c9:75a7:5c25 with SMTP id 98e67ed59e1d1-2cb7751ff7dmr11165433a91.15.1721474841301; Sat, 20 Jul 2024 04:27:21 -0700 (PDT) Received: from google.com ([2600:1702:a20:5750::48]) by smtp.gmail.com with ESMTPSA id 98e67ed59e1d1-2cb77348f78sm4463072a91.32.2024.07.20.04.27.20 (version=TLS1_2 cipher=ECDHE-ECDSA-AES128-GCM-SHA256 bits=128/128); Sat, 20 Jul 2024 04:27:20 -0700 (PDT) Date: Sat, 20 Jul 2024 04:27:18 -0700 From: Noah Misch To: Nazir Bilal Yavuz Cc: PostgreSQL Hackers Subject: Re: Use read streams in CREATE DATABASE command when the strategy is wal_log Message-ID: <20240720112718.68.nmisch@google.com> References: <20240711235209.f6.nmisch@google.com> <20240716121935.fa.nmisch@google.com> <20240717204147.09@rfd.leadboat.com> MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: User-Agent: Mutt/2.2.12 (2023-09-09) List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk On Thu, Jul 18, 2024 at 02:11:13PM +0300, Nazir Bilal Yavuz wrote: > v4 is attached. Removal of the PinBufferForBlock() comment about the "persistence = RELPERSISTENCE_PERMANENT" fallback started to feel like a loss. I looked for a way to re-add a comment about the fallback. https://coverage.postgresql.org/src/backend/storage/buffer/bufmgr.c.gcov.html shows no test coverage of that fallback, and I think the fallback is unreachable. Hence, I've removed the fallback in a separate commit. I've pushed that and your three patches. Thanks.