public inbox for [email protected]  

help / color / mirror / Atom feed

From: Mahdi Bahrami <[email protected]>
To: Álvaro Herrera <[email protected]>
Cc: [email protected]
Subject: Re: Database creation performance drop going from pg 14 to pg 15+
Date: Wed, 28 May 2025 14:39:20 +0330
Message-ID: <[email protected]> (raw)
In-Reply-To: <[email protected]>
References: <[email protected]>

Thanks for the hint, that was exactly it! I also asked the original author of the issue and he has confirmed the performance of pg 15+ now matches those of pg 13/14.

As mentioned "This issue is not necessarily a big deal to us, but can anyone please explain the why?" so it was partially out of curiosity, and partially because of the way the author of the issue is using Postgres which apparently is sensitive to these milliseconds.

Not exactly sure what's their set up, but they did mention with the PostgresNIO SASL improvements which saves only some 10-20-30-40 milliseconds or so, their tests now run in 15s instead of 1m30s, which then it means they can now use pg versions higher than pg 13 and still have around the same performance.
I think they run tests in parallel, and they possibly recreate the whole DB once for each test.

view thread (7+ messages)  latest in thread

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]
  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