| From: | "Mahdi Bahrami" <pgsql(at)mahdibm(dot)com> |
|---|---|
| To: | Álvaro Herrera <alvherre(at)kurilemu(dot)de> |
| Cc: | pgsql-performance(at)lists(dot)postgresql(dot)org |
| Subject: | Re: Database creation performance drop going from pg 14 to pg 15+ |
| Date: | 2025-05-28 11:09:20 |
| Message-ID: | ad74d853-bd28-4e72-9ba5-1ca624c2d879@app.fastmail.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-performance |
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.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Thomas Munro | 2025-05-28 11:29:04 | Re: Database creation performance drop going from pg 14 to pg 15+ |
| Previous Message | Álvaro Herrera | 2025-05-27 15:07:12 | Re: Database creation performance drop going from pg 14 to pg 15+ |