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 1uf0Qw-000sOf-Ql for pgsql-general@arkaria.postgresql.org; Thu, 24 Jul 2025 18:12:47 +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 1uf0Qv-009oEY-UZ for pgsql-general@arkaria.postgresql.org; Thu, 24 Jul 2025 18:12:46 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1uf0Qu-009oEQ-Uw for pgsql-general@lists.postgresql.org; Thu, 24 Jul 2025 18:12:45 +0000 Received: from fhigh-b4-smtp.messagingengine.com ([202.12.124.155]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.96) (envelope-from ) id 1uf0Qr-000dx8-1h for pgsql-general@lists.postgresql.org; Thu, 24 Jul 2025 18:12:44 +0000 Received: from phl-compute-01.internal (phl-compute-01.phl.internal [10.202.2.41]) by mailfhigh.stl.internal (Postfix) with ESMTP id 45D157A00CF; Thu, 24 Jul 2025 14:12:40 -0400 (EDT) Received: from phl-imap-04 ([10.202.2.82]) by phl-compute-01.internal (MEProxy); Thu, 24 Jul 2025 14:12:40 -0400 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=barre.sh; h=cc :content-transfer-encoding:content-type:content-type:date:date :from:from:in-reply-to:in-reply-to:message-id:mime-version :references:reply-to:subject:subject:to:to; s=fm1; t=1753380760; x=1753467160; bh=eA3Bbn7uacwqQd0rE/CcyTRwU+7cUEzlzsPnvX/Pe+Q=; b= oUJLyQtWaA2vl79bdTzer3otwTKee/VhsypjsaA9i9qOn7dXHjQ9Tb8gb+A8ugub vILmXutpxOpboRtdeGmS9hLnDftFrVO7CdESrR37VzylgqhgGIEgjn1wkRRAi0XZ wzDV+uWIFxUfi+hkSAb+T+tkG/VmW+rB+rnZHG8y5kx8WKhtVIbnNVuPMGH2fTbw F/rqfSpbhN8xHLnDTUWDAZ1zy8TlefR2ICSfjvpIvcP2PM7zCTvXh5YYbZiG4Ove 4CkVahDvOpKUTJsJW2QcRlNKoaZpFW9ouyYx/oPKTcvEA+U8L3ZMsnblBH19ZFFT YJiqYtyC/t5yFyh66+4cwA== DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d= messagingengine.com; h=cc:content-transfer-encoding:content-type :content-type:date:date:feedback-id:feedback-id:from:from :in-reply-to:in-reply-to:message-id:mime-version:references :reply-to:subject:subject:to:to:x-me-proxy:x-me-sender :x-me-sender:x-sasl-enc; s=fm2; t=1753380760; x=1753467160; bh=e A3Bbn7uacwqQd0rE/CcyTRwU+7cUEzlzsPnvX/Pe+Q=; b=QBN/BW3ykpYbFJWCL GpEBcCKLom0+XtZGraO6sCX1ZGsW/51xX6yUYZEkKfPF6VelVyhtQvZz1F1J8K2p JZWd5hrQSpVpFvS4krsp9vySQAtwQPFJlWW//Dd5GOggZc6OfkHUaUM4x8YFjbTe BWTZxyHwG0FV2Bs3fkt1dhmgfujRKUHYqUamwulk6QMp96CIFR2dr8QuLhaibgiO ON70Noq2RyjRmhGt0WUahz/0HuczNYeX/5dh2fLB24M5V0yXAue1edSYHUGsd0xU YYwF531Dkj6l317XEmlp2bYFpRrPFdAwHTt9xLZcFgZ+lrX1l3HBZDxGqO+U4ahd TkE5g== X-ME-Sender: X-ME-Proxy-Cause: gggruggvucftvghtrhhoucdtuddrgeeffedrtdefgdekudefgecutefuodetggdotefrod ftvfcurfhrohhfihhlvgemucfhrghsthforghilhdpuffrtefokffrpgfnqfghnecuuegr ihhlohhuthemuceftddtnecusecvtfgvtghiphhivghnthhsucdlqddutddtmdenucfjug hrpefoggffhffvkfgjfhfutgfgsehtjeertdertddtnecuhfhrohhmpedfrfhivghrrhgv uceurghrrhgvfdcuoehpihgvrhhrvgessggrrhhrvgdrshhhqeenucggtffrrghtthgvrh hnpeeugeetjeeutdeiudefteffudffueekhfdvieetfedtudehffelveejhfehhfeiffen ucevlhhushhtvghrufhiiigvpedtnecurfgrrhgrmhepmhgrihhlfhhrohhmpehpihgvrh hrvgessggrrhhrvgdrshhhpdhnsggprhgtphhtthhopedvpdhmohguvgepshhmthhpohhu thdprhgtphhtthhopehlrghurhgvnhiirdgrlhgsvgestgihsggvrhhtvggtrdgrthdprh gtphhtthhopehpghhsqhhlqdhgvghnvghrrghlsehlihhsthhsrdhpohhsthhgrhgvshhq lhdrohhrgh X-ME-Proxy: Feedback-ID: i97614980:Fastmail Received: by mailuser.phl.internal (Postfix, from userid 501) id 7B551B6006B; Thu, 24 Jul 2025 14:12:39 -0400 (EDT) X-Mailer: MessagingEngine.com Webmail Interface MIME-Version: 1.0 X-ThreadId: T89c86ea8eb4c36ce Date: Thu, 24 Jul 2025 20:12:19 +0200 From: "Pierre Barre" To: "Laurenz Albe" , pgsql-general@lists.postgresql.org Message-Id: In-Reply-To: <3345416f84147603587ff8656cc3ac95b6787744.camel@cybertec.at> References: <3345416f84147603587ff8656cc3ac95b6787744.camel@cybertec.at> Subject: Re: PostgreSQL on S3-backed Block Storage with Near-Local Performance Content-Type: text/plain Content-Transfer-Encoding: 7bit List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk > "NFS" is a key word that does not inspire confidence in PostgreSQL circles... Coming back to this, I just implemented 9P, which should translates to proper semantics for FSYNC. mount -t 9p -o trans=tcp,port=5564,version=9p2000.L,msize=65536,access=user 127.0.0.1 /mnt/9p Best, Pierre On Fri, Jul 18, 2025, at 06:40, Laurenz Albe wrote: > On Fri, 2025-07-18 at 00:57 +0200, Pierre Barre wrote: >> Looking forward to your feedback and questions! > > I think the biggest hurdle you will have to overcome is to > convince notoriously paranoid DBAs that this tall stack > provides reliable service, honors fsync() etc. > > Performance is great, but it is not everything. If things > perform surprisingly well, people become suspicious. > >> P.S. The full project includes a custom NFS filesystem too. > > "NFS" is a key word that does not inspire confidence in > PostgreSQL circles... > > Yours, > Laurenz Albe