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 1uKFgu-00HKch-SE for pgsql-performance@arkaria.postgresql.org; Wed, 28 May 2025 12:15:29 +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 1uKFgt-00H1Eu-IM for pgsql-performance@arkaria.postgresql.org; Wed, 28 May 2025 12:15:27 +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 1uKFgs-00H1Em-RH for pgsql-performance@lists.postgresql.org; Wed, 28 May 2025 12:15:27 +0000 Received: from fout-b2-smtp.messagingengine.com ([202.12.124.145]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.96) (envelope-from ) id 1uKFgq-000NFV-2b for pgsql-performance@lists.postgresql.org; Wed, 28 May 2025 12:15:25 +0000 Received: from phl-compute-02.internal (phl-compute-02.phl.internal [10.202.2.42]) by mailfout.stl.internal (Postfix) with ESMTP id 0A5541140160; Wed, 28 May 2025 08:15:24 -0400 (EDT) Received: from phl-imap-17 ([10.202.2.105]) by phl-compute-02.internal (MEProxy); Wed, 28 May 2025 08:15:24 -0400 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=mahdibm.com; h= cc:cc: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=fm2; t=1748434523; x=1748520923; bh=/zNUrQdqPS 6mHTuglQAH8V130jWb3HZg23HhXRVi7j4=; b=PM9xpHLcFTSUcgSDQm+m7aeROx YI8JeRy2dQVF96/KP2+TPJ3hlmWKxiHiAPr/Qt15LSrXfN459tTbIZ5yFXb83kXc 8Q58Ws+oXgxkDLAiy/Nn0C/rWVtCtXYfiOW6fozrqV6xFOz8yB6jstN5PfGzrW5v vClFoLI+PWjaUyky4dOZ36I1pzd5bznGUEBhfgbqLvVyqor3FW6mgBWGZML6aGdx n1c8onfIKUzYIz/imv4xz56z3ETALmx0cuS2qDkn7ViF7LB2c8CysPkB+LIRXFCJ 6Fby4VkHzXx6FIsG6/skUB2wROpQXO1fQCdqnKlCJhHc3WNbTl44L0juuOwQ== DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d= messagingengine.com; h=cc:cc: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=fm1; t= 1748434523; x=1748520923; bh=/zNUrQdqPS6mHTuglQAH8V130jWb3HZg23H hXRVi7j4=; b=VLBVfYyashzaQU3LjKSRaolEJw/rw9tTqI0zfttZICJslmt8Cpg 7JbUgK2G54+OnklIGrCvKAtkf/ljld/Oe3qQdjgE0V7lK2MclbO5QjXF6e5teHox V1tN+2lUtNxIANHiTC/5M8uDNjbdbRmX3pkush/RNOXzNAM6E2/XwCTyi9W2544H RfDnqmQIIK9GQiufChmxtYaG0gf8WjJGUj/ZIm5IQmFrFfFtvo6kCA6p4BrQtnJd C6fFBIU54Bhl6OtV7MIrZz8LXOGixaNpkppNrKYnrLZo4xLuHGLUPZDIE3TRIpwY +rrd2C7KZ3oxRUSlnBd2jEhixnK9NtX3WuQ== X-ME-Sender: X-ME-Proxy-Cause: gggruggvucftvghtrhhoucdtuddrgeeffedrtddtgddvfedvfeculddtuddrgeefvddrtd dtmdcutefuodetggdotefrodftvfcurfhrohhfihhlvgemucfhrghsthforghilhdpggft fghnshhusghstghrihgsvgdpuffrtefokffrpgfnqfghnecuuegrihhlohhuthemuceftd dtnecusecvtfgvtghiphhivghnthhsucdlqddutddtmdenucfjughrpefoggffhffvvefk jghfufgtsegrtderreertddtnecuhfhrohhmpedfofgrhhguihcuuegrhhhrrghmihdfuc eophhgshhqlhesmhgrhhguihgsmhdrtghomheqnecuggftrfgrthhtvghrnhepleeihfel vddttdejjeekteegteduledtteefffelueektddtfefhgeetgeeigfegnecuvehluhhsth gvrhfuihiivgeptdenucfrrghrrghmpehmrghilhhfrhhomhepphhgshhqlhesmhgrhhgu ihgsmhdrtghomhdpnhgspghrtghpthhtohepfedpmhhouggvpehsmhhtphhouhhtpdhrtg hpthhtohepthhhohhmrghsrdhmuhhnrhhosehgmhgrihhlrdgtohhmpdhrtghpthhtohep rghlvhhhvghrrhgvsehkuhhrihhlvghmuhdruggvpdhrtghpthhtohepphhgshhqlhdqph gvrhhfohhrmhgrnhgtvgeslhhishhtshdrphhoshhtghhrvghsqhhlrdhorhhg X-ME-Proxy: Feedback-ID: ib7d648f3:Fastmail Received: by mailuser.phl.internal (Postfix, from userid 501) id 91F57C40065; Wed, 28 May 2025 08:15:23 -0400 (EDT) X-Mailer: MessagingEngine.com Webmail Interface MIME-Version: 1.0 X-ThreadId: T9df08ae4920d62bd Date: Wed, 28 May 2025 15:45:02 +0330 From: "Mahdi Bahrami" To: "Thomas Munro" Cc: =?UTF-8?Q?=C3=81lvaro_Herrera?= , pgsql-performance@lists.postgresql.org Message-Id: In-Reply-To: References: <202505271507.xvfbdztae74a@alvherre.pgsql> Subject: Re: Database creation performance drop going from pg 14 to pg 15+ Content-Type: multipart/alternative; boundary=e5bee6ff850047dbbd56d5c788a9143c List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --e5bee6ff850047dbbd56d5c788a9143c Content-Type: text/plain Content-Transfer-Encoding: 7bit To be clear the "15s instead of 1m30s" was related to another issue about SASL implementation of PostgresNIO being slow, not this CREATE DATABASE strategy change. I was just trying to explain that in their set up, these saved milliseconds do matter for whatever reason. --e5bee6ff850047dbbd56d5c788a9143c Content-Type: text/html Content-Transfer-Encoding: 7bit To be clear the "15s instead of 1m30s" was related to another issue about SASL implementation of PostgresNIO being slow, not this CREATE DATABASE strategy change. I was just trying to explain that in their set up, these saved milliseconds do matter for whatever reason.

--e5bee6ff850047dbbd56d5c788a9143c--