Request a Demo
Home   >   mailing lists

Re: Possible regression in PG18 beta1 - Mailing list pgsql-hackers

From Sadeq Dousti
Subject Re: Possible regression in PG18 beta1
Date
Msg-id CADE6LvihfgomXMmdAoy7qXWWOCNgk4SgwozpFqrLFmuZy7qGtA@mail.gmail.com
Whole thread Raw
In response to Re: Possible regression in PG18 beta1  (Sami Imseih <samimseih@gmail.com>)
List pgsql-hackers
Tree view

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

pgsql-hackers by date:

Previous
From: Sami Imseih
Date:
Subject: Re: Possible regression in PG18 beta1
Next
From: Álvaro Herrera
Date:
Subject: Re: Revisiting {CREATE INDEX, REINDEX} CONCURRENTLY improvements