| From: | Sadeq Dousti <msdousti(at)gmail(dot)com> |
|---|---|
| To: | Sami Imseih <samimseih(at)gmail(dot)com> |
| Cc: | Christophe Courtois <christophe(dot)courtois(at)dalibo(dot)com>, PostgreSQL Hackers <pgsql-hackers(at)lists(dot)postgresql(dot)org> |
| Subject: | Re: Possible regression in PG18 beta1 |
| Date: | 2025-05-18 15:56:24 |
| Message-ID: | CADE6LvihfgomXMmdAoy7qXWWOCNgk4SgwozpFqrLFmuZy7qGtA@mail.gmail.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
> In my tests I build from source from both the 17 stable and head branch
> and use the same build options.
>
OK, I built 17 from REL_17_STABLE, and got the same behavior as the
Homebrew PG17:
* First run: 135 ms
* Subsequent runs: 169 ms, 181 ms, 187 ms, 177 ms, 170 ms
For comparison, with PG18:
* First run: 150 ms
* Subsequent runs: 183 ms, 182 ms, 185 ms, 187 ms, 180 ms
On the first and second runs, PG17 is consistently faster.
It's also strange to me that subsequent runs are consistently slower than
the first run.
Best Regards,
Sadeq Dousti
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Álvaro Herrera | 2025-05-18 15:56:54 | Re: Revisiting {CREATE INDEX, REINDEX} CONCURRENTLY improvements |
| Previous Message | Mihail Nikalayeu | 2025-05-18 15:16:00 | Re: Issues with ON CONFLICT UPDATE and REINDEX CONCURRENTLY |