public inbox for [email protected]  

help / color / mirror / Atom feed

From: Mahdi Bahrami <[email protected]>
To: Mahdi Bahrami <[email protected]>
To: Thomas Munro <[email protected]>
Cc: Álvaro Herrera <[email protected]>
Cc: [email protected]
Subject: Re: Database creation performance drop going from pg 14 to pg 15+
Date: Thu, 05 Jun 2025 21:55:04 +0330
Message-ID: <[email protected]> (raw)
In-Reply-To: <[email protected]>
References: <[email protected]>
	<[email protected]>
	<CA+hUKGJaCTTspp7bQPG2nwDmzk_XzAdNvFwcx4sWHt2QUEK4QA@mail.gmail.com>
	<[email protected]>

Here's what the OP of the PostgresNIO issue has mentioned about what performance impact usage of `file_copy` has in his setup (https://github.com/SwiftPackageIndex/SwiftPackageIndex-Server/pull/3812):

`Series: Default Strategy
Suite AllTests passed after 5.081 seconds
Suite AllTests passed after 5.274 seconds
Suite AllTests passed after 5.306 seconds
Suite AllTests passed after 5.224 seconds
Suite AllTests passed after 6.343 seconds
Suite AllTests passed after 5.450 seconds
Series: file_copy Strategy
Suite AllTests passed after 4.729 seconds
Suite AllTests passed after 4.755 seconds
Suite AllTests passed after 4.739 seconds
Suite AllTests passed after 4.772 seconds
Suite AllTests passed after 4.866 seconds
Suite AllTests passed after 4.855 seconds`

This is them running the tests in parallel multiple times with and without file_copy, just to benchmark.
Overall ~0.5-6s / ~10% speedup, which isn't too significant at this level, but is still a noticeable relative improvement.

view thread (7+ messages)

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: [email protected]
  Cc: [email protected], [email protected], [email protected], [email protected]
  Subject: Re: Database creation performance drop going from pg 14 to pg 15+
  In-Reply-To: <[email protected]>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox