Re: Database creation performance drop going from pg 14 to pg 15+

2025-06-05 Thread Mahdi Bahrami
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

Re: Database creation performance drop going from pg 14 to pg 15+

2025-05-28 Thread Mahdi Bahrami
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.

Re: Database creation performance drop going from pg 14 to pg 15+

2025-05-28 Thread Mahdi Bahrami
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