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 1uKEyg-00H3tn-UM for pgsql-performance@arkaria.postgresql.org; Wed, 28 May 2025 11:29: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 1uKEyf-00Gego-N9 for pgsql-performance@arkaria.postgresql.org; Wed, 28 May 2025 11:29:45 +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 1uKEyf-00GefJ-Ce for pgsql-performance@lists.postgresql.org; Wed, 28 May 2025 11:29:45 +0000 Received: from mail-oo1-xc34.google.com ([2607:f8b0:4864:20::c34]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.96) (envelope-from ) id 1uKEyd-000Muk-1t for pgsql-performance@lists.postgresql.org; Wed, 28 May 2025 11:29:44 +0000 Received: by mail-oo1-xc34.google.com with SMTP id 006d021491bc7-60bd5f2f1b7so24743eaf.0 for ; Wed, 28 May 2025 04:29:43 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20230601; t=1748431782; x=1749036582; darn=lists.postgresql.org; h=content-transfer-encoding:cc:to:subject:message-id:date:from :in-reply-to:references:mime-version:from:to:cc:subject:date :message-id:reply-to; bh=xZXbYOBIn+gpLE521rN0SVkD8UCYFsb8gE3/AfnZ6qw=; b=WHf7oNtnRqApFcDSovA3Wa8mPDIqI5ygyO9n98ESfg9gWO+0U/2u7NU8rO+ZJqRBnA if1YAiQRiZpVoEM4lI3zmi7+XwGS97lmC58KSOz3teN9m8rHgLr8FUV6wPgvQV/x46FA GoSmYDWmG08YnRgacDrHokR0o5EvJ5FA/UdDbzyMIQAeZwcAlurNVzL5IBLObpveOsAK q6ysMqEtjy4OXwV+U+wqXCpaCZEQxV7iTpNy2JQSBB2A5HlZqp5xvcbflz7XBzXycTy3 a3ATBuu9Rdfd3rqaJ4mNv/wVXjyi8Gt1q3xyEXYDvl8q1Vq4Zcqao+4ROOwN7lptMJAz L6Jw== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1748431782; x=1749036582; h=content-transfer-encoding:cc:to:subject:message-id:date:from :in-reply-to:references:mime-version:x-gm-message-state:from:to:cc :subject:date:message-id:reply-to; bh=xZXbYOBIn+gpLE521rN0SVkD8UCYFsb8gE3/AfnZ6qw=; b=jUdI46oThwNPOjypqmmYjM0miHG0OWDQGUz7LRY965hrvgYRFO5+Ei7VaZk38z0DTh OdV1/TiBFv8JOOCefkBkrsieH/MRiBQULOIkWLT8WwyJBGfoNMQ/y2WaKWi4FCzRR6zR SwY0I01dHpKieHtwo5JvgEDDfs6RfH4GCZJpntAvc3uedxisIOkAIyYYUK7Bd6tneh+a 1AYTAIGgJVva6BOPnPDhBdNnS+d/xZtaPtJHwqcC86d+TBhmziSwbietIGyqSt2vpU0l aukKgR0gPC1UZ3McdZ8xXIF8296/S6zUmkLqDs4g4oWZZaJMbmuV+MmCo5H+TZFvPnBT JfqQ== X-Forwarded-Encrypted: i=1; AJvYcCXmPWnYt+aUHXE7//yJYvdIPEiyemG0FDPrB+DxVFa1O/AAdUNAEwOGRDmN4ozqmCygL6UtVCXAYctV4v2RgmQLMA==@lists.postgresql.org X-Gm-Message-State: AOJu0YyaFp2ECaSHc6RLtWLmnwGehVA1ITLNoQ2l7TFRERrHAXt+XoIu UlY/eRQ+EkUj6agQdiAIjWNnr79IvYItf4bTcysgx6PEylYbecj5avct7KpOXRZ+A0/kJQrrD8V 11cJshgVbmbdmJKCZ9SS23JhfnsNBzVVuGePW X-Gm-Gg: ASbGncuavZJ53fKCs+ZcbPMgJ9bVqXM4L5S8z0jYdN75pg1R/ahVFyTh6aFJHVXO0Rb UCcYX8jLOs5EmVRoNSO3YoUDK3PfKp/Le05xINQTKE/Zb2EzO1MiVXTYE48af6UrbjV4MQgOhvC bCUy+XSbbRyjcF6dqBuDJ3vVOL+Y9UI4hT28QLqSQniIN2ntTYMTZSiRhRYOrBtIzkcPs= X-Google-Smtp-Source: AGHT+IEWi5CeXl4xlHkf1qFt8pSBWbDSjz158KF2m+cvbmuw+wsZenk+/4DkIkiIg18Wy1xCV/OqkYbYbK+ZUTuXRHk= X-Received: by 2002:a4a:d12c:0:b0:609:dd33:a69d with SMTP id 006d021491bc7-60bd82f0606mr206317eaf.0.1748431782465; Wed, 28 May 2025 04:29:42 -0700 (PDT) MIME-Version: 1.0 References: <202505271507.xvfbdztae74a@alvherre.pgsql> In-Reply-To: From: Thomas Munro Date: Wed, 28 May 2025 23:29:04 +1200 X-Gm-Features: AX0GCFuaSYCpDL2lObXgvaD2a3g6U-uVjncntPXeKftyE9HuGwgZzBUKDIq_xQo Message-ID: Subject: Re: Database creation performance drop going from pg 14 to pg 15+ To: Mahdi Bahrami Cc: =?UTF-8?Q?=C3=81lvaro_Herrera?= , pgsql-performance@lists.postgresql.org Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk On Wed, May 28, 2025 at 11:09=E2=80=AFPM Mahdi Bahrami = wrote: > their tests now run in 15s instead of 1m30s Wow. If/when they get to v18, they might also try setting file_copy_method=3Dclone when using strategy=3Dfile_copy.