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 1uccuD-00F418-42 for pgsql-general@arkaria.postgresql.org; Fri, 18 Jul 2025 04:41:09 +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 1uccuA-007b8F-Rt for pgsql-general@arkaria.postgresql.org; Fri, 18 Jul 2025 04:41:07 +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 1uccuA-007b85-G8 for pgsql-general@lists.postgresql.org; Fri, 18 Jul 2025 04:41:07 +0000 Received: from mail-ed1-x52e.google.com ([2a00:1450:4864:20::52e]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.96) (envelope-from ) id 1uccu6-008NVR-27 for pgsql-general@lists.postgresql.org; Fri, 18 Jul 2025 04:41:06 +0000 Received: by mail-ed1-x52e.google.com with SMTP id 4fb4d7f45d1cf-60c01f70092so2845623a12.3 for ; Thu, 17 Jul 2025 21:41:02 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=cybertec.at; s=google; t=1752813659; x=1753418459; darn=lists.postgresql.org; h=mime-version:user-agent:content-transfer-encoding:references :in-reply-to:date:to:from:subject:message-id:from:to:cc:subject:date :message-id:reply-to; bh=+/zW7w2uACMHBE2ry+HrSyhfGYsbflo4YxFL7nQCkLI=; b=AVJHub7GHxaKdlXQBi8aJokmMtmnM2h+XILaIwwT+NsJUeqDOFHPzHft66xFuFHrrI 2Uep4IimfELaRXT4BPxLOjseOsBvQsca39yVZt8LIufzqo1YlxvhG6in2UIDbV/ITxYK CpE/VEuqrjC/+cd4PUY/KfkkdYt3FXZ462QkI7SJvDVHaGjaKoJ1I+CgDL6LwrwtIUD7 tA4XYRcxcW7dSboOLicUhNPtbmeziulE8Vb/hNT9cGSmjUxyv9BgLDgYvx4GQyz8W3A2 RhzEzPc89TfydAW3eGU67iEiWx1dIqhfPVxpqfuDAC8B5j9DeyJmRD1Y7HQnTc1y/n1K Y9oA== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1752813659; x=1753418459; h=mime-version:user-agent:content-transfer-encoding:references :in-reply-to:date:to:from:subject:message-id:x-gm-message-state:from :to:cc:subject:date:message-id:reply-to; bh=+/zW7w2uACMHBE2ry+HrSyhfGYsbflo4YxFL7nQCkLI=; b=XxRLwTnVqVImhxqAVVZxnpkmFvLR/fR1yY9zuFI/TqNivDAZ/pyEcGdnEKF8eY5M7q qhtQUHTBR8QOa9Z0cwgopDMW04puniFtmBXe+2gzk6XDAY5kCiQax8lzIrqgL2dPWrRI +BIJhSXvZsou12pISFhzyh7QW4mjA0bidtZjGKj8chCl4C73xGmkNnD2DOlLRTi6pGFY 4n1XsVsGg9vobKipTkDhN+WR0OY4fOC1ggV8y0x/BG4peWA7SrEdYmPFPOx8wPkja0A8 5b78QZV8OBesX3pWh1Nq9O8Tau677baComRwze2OMkSN/PPFmjByuiGizQ6JNzVqvFwY f/PA== X-Forwarded-Encrypted: i=1; AJvYcCVXvsdSJ7OFBSJWM989lY1COMsaTUiKAUTXCsCnu8GKxm3O8aCjyDOw6NlStkXWMUTUd7E7zeS1SF8JNgb5@lists.postgresql.org X-Gm-Message-State: AOJu0YzCTvIXzWCo9v3OHoM5r0o1WCTRPkG/SOf+8mZjXexwSqe6BLZ3 cx4Hqd0wDqmkjEJf1rj8RU75AW5mFms5y2iC3ZhqtUKVDlj83f3P0VL5cv5pxOAFgkJdlx8Xlew tsnqF X-Gm-Gg: ASbGncuKUffgXVFcBsNOhuupd+Fg8enGBj33Qcb4QiDRSfm+hTU4rAXHY9+Jav8I30s 1QkgS5AxeOqKYzIK4h0jMojtcv8WTluvL9XOMaXscU1E16w7x4TK8ntamCXLY7shCC2uzqvB484 6G2BPFKV6Dc4pzIWCP+1sTkhZoo0T1QTLJ/JPzCHMlmulu6v56DCwG8twQxdEqTKxQ6bEhqY/36 GtrT23Cqn8k1Fcv0ovKmeN+A8md2wE/ywE9U07Yu7QollXb7cVi8FNzjgdI/6riYifSA+OLG6CB lf5qdmysUk6C2j8AEmBXsWwxPlUlzP8dL7lATd+tQU2X+4Po/C5ktRlGiER98toeR8NDD5VFL65 XWvtFeFf4N1Yqd41RzaU7+W7gblqoWRjJJK9wtA0LQtV6tvgd1FNP X-Google-Smtp-Source: AGHT+IEBi35UuwAyHfr6q4FYKQdVvytxAglCwh2CXe+gBgdF5dgqml/gI61aFSapd53VV+U9IkVsxQ== X-Received: by 2002:a17:907:c808:b0:ae3:a3f7:ad8e with SMTP id a640c23a62f3a-aec4fb05ee0mr560435166b.25.1752813659515; Thu, 17 Jul 2025 21:40:59 -0700 (PDT) Received: from laurenz.albe-K4N0CV00F97414D ([2001:871:260:99eb:ca9d:7ee1:39c4:3753]) by smtp.gmail.com with ESMTPSA id a640c23a62f3a-aec6c79a089sm50761866b.20.2025.07.17.21.40.59 (version=TLS1_3 cipher=TLS_AES_256_GCM_SHA384 bits=256/256); Thu, 17 Jul 2025 21:40:59 -0700 (PDT) Message-ID: <3345416f84147603587ff8656cc3ac95b6787744.camel@cybertec.at> Subject: Re: PostgreSQL on S3-backed Block Storage with Near-Local Performance From: Laurenz Albe To: Pierre Barre , pgsql-general@lists.postgresql.org Date: Fri, 18 Jul 2025 06:40:58 +0200 In-Reply-To: References: Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable User-Agent: Evolution 3.56.2 (3.56.2-1.fc42) MIME-Version: 1.0 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk 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