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 1uf1s6-001AdQ-2H for pgsql-general@arkaria.postgresql.org; Thu, 24 Jul 2025 19:44:54 +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 1uf1s5-00AcCI-5l for pgsql-general@arkaria.postgresql.org; Thu, 24 Jul 2025 19:44:53 +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 1uf1s4-00AcCA-NK for pgsql-general@lists.postgresql.org; Thu, 24 Jul 2025 19:44:53 +0000 Received: from flamingo.ash.relay.mailchannels.net ([23.83.222.60]) by makus.postgresql.org with smtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.96) (envelope-from ) id 1uf1s2-000bQZ-36 for pgsql-general@lists.postgresql.org; Thu, 24 Jul 2025 19:44:52 +0000 X-Sender-Id: dreamhost|x-authsender|nico@cryptonector.com Received: from relay.mailchannels.net (localhost [127.0.0.1]) by relay.mailchannels.net (Postfix) with ESMTP id 8CF8A8C34B4; Thu, 24 Jul 2025 19:44:49 +0000 (UTC) Received: from pdx1-sub0-mail-a290.dreamhost.com (100-114-140-88.trex-nlb.outbound.svc.cluster.local [100.114.140.88]) (Authenticated sender: dreamhost) by relay.mailchannels.net (Postfix) with ESMTPA id 37F3B8C2E80; Thu, 24 Jul 2025 19:44:49 +0000 (UTC) ARC-Seal: i=1; s=arc-2022; d=mailchannels.net; t=1753386289; a=rsa-sha256; cv=none; b=xz0l67mgnX8z6WdpgMt7K4mldNEUMbkswJCshXHfo136+NyjCuhBf1Eq31QPt5wW1qMyt0 SsbkGxHUKwXXpDCCjVoENk7AsA2t1fecrFKYBeOcfTbO5SIaeBk46qDCCfnuszy4nmhD5l jYcF/9gO64QjSC7GkhHMG33zMl8pQJPUrt4zImJei8peicpjKyaieCYmDDlsgOjVBmFeVd v9EsHpQvPF2XDhbnhQqxqBeFvbfxGzbeDFmhqUYsK0mJGBnDKHVDGkpMWGSuZ41VLhmt6O 7ZFh0LjUuaxEQWHcy6VoeGV81r8hYF1Oq4bj7eqYhBv8BJwWmkBEWu2mFb1dUQ== ARC-Message-Signature: i=1; a=rsa-sha256; c=relaxed/relaxed; d=mailchannels.net; s=arc-2022; t=1753386289; 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: in-reply-to:in-reply-to:references:references:dkim-signature; bh=71sglPyiOaxz3AHiVlbawpjGnuZF/VNok1pdWc2oYtg=; b=bxKETEDsU5MC2c646fc/T+FTCiheUdNhfkjcW7gTY4AVJ+XYzLowhpnH+1Hi17lHnHhKUG sGd8QD6m/ey2unXGnO+SVCFR704MiOzM2Q7+oaO6W89XEFOCSy25j+opBBsy2wFNd27tSS 7Q8aXDczJ7YSFqJH7BQpdAo+zze+YTNZz60/CwXG8j+gpjaSNX9sdX2Z+Fd69Q1N5MnhE7 cciBhuVpHJG1EQvBnPpC6MpUPccgh++br5QAY3dtSmFI80i4Sl2Y1obX2+6ySwEIMrOWFi vOw30Ies4SDMr/mXXDQWfk7tmLT28Hccs+Qne09pNsqikoIYNn2DM8tspvU1BQ== ARC-Authentication-Results: i=1; rspamd-7df5bc8bc6-6k7hl; auth=pass smtp.auth=dreamhost smtp.mailfrom=nico@cryptonector.com X-Sender-Id: dreamhost|x-authsender|nico@cryptonector.com X-MC-Relay: Neutral X-MailChannels-SenderId: dreamhost|x-authsender|nico@cryptonector.com X-MailChannels-Auth-Id: dreamhost X-Cooperative-Vacuous: 7c328c892e669fb1_1753386289456_376012461 X-MC-Loop-Signature: 1753386289456:2648905420 X-MC-Ingress-Time: 1753386289456 Received: from pdx1-sub0-mail-a290.dreamhost.com (pop.dreamhost.com [64.90.62.162]) (using TLSv1.3 with cipher TLS_AES_256_GCM_SHA384) by 100.114.140.88 (trex/7.1.3); Thu, 24 Jul 2025 19:44:49 +0000 Received: from ubby (syn-075-081-095-064.res.spectrum.com [75.81.95.64]) (using TLSv1.3 with cipher TLS_AES_256_GCM_SHA384 (256/256 bits) key-exchange ECDHE (P-256) server-signature RSA-PSS (2048 bits) server-digest SHA256) (No client certificate requested) (Authenticated sender: nico@cryptonector.com) by pdx1-sub0-mail-a290.dreamhost.com (Postfix) with ESMTPSA id 4bp1g443HlzB9; Thu, 24 Jul 2025 12:44:48 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=cryptonector.com; s=dreamhost; t=1753386289; bh=71sglPyiOaxz3AHiVlbawpjGnuZF/VNok1pdWc2oYtg=; h=Date:From:To:Cc:Subject:Content-Type; b=dbealnTlY9E+s7DKVj6qxhs52TOg5KX0940Zip5SmD/DZna0jD/appv1b4M35IjOC sHxkEnv6njf+upmu/9HwAZ/wqFQePS1YiGfWxTcCowINdiG4bYb3rsuwl2rHQKKCkU /m+shTUQyB3lD12Nm2CKeLlE/khawmOY+xbe1eLTrsQbiujsp7XC23SsUQIks36CrZ eYRUEX+nKm1/czqvkzpa3HAI5nZWToBbIgwW0Kg1A9Sk/FWP7kGRMHnRGbvCakbAN4 4WE3bZ0tkyAuH5aMttA7D/jpTO5zRGpQxTTvl5FonRPD5kDo8TYqPga/lN89Bx6Wgc xGsSDSuMeFodQ== Date: Thu, 24 Jul 2025 14:44:46 -0500 From: Nico Williams To: Pierre Barre Cc: Seref Arikan , pgsql-general@lists.postgresql.org Subject: Re: PostgreSQL on S3-backed Block Storage with Near-Local Performance Message-ID: References: <8188513c-e089-4273-b2be-16dd0a5a0a80@app.fastmail.com> MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <8188513c-e089-4273-b2be-16dd0a5a0a80@app.fastmail.com> List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk On Fri, Jul 18, 2025 at 12:57:39PM +0200, Pierre Barre wrote: > - Postgres configured accordingly memory-wise as well as with > synchronous_commit = off, wal_init_zero = off and wal_recycle = off. Bingo. That's why it's fast (synchronous_commit = off). It's also why it's not safe _unless_ you have a local, fast, persistent ZIL device (which I assume you don't). Nico --