On Fri, Jul 18, 2025 at 4:09 PM Tom Lane <t...@sss.pgh.pa.us> wrote:
>
> "Michael J. Baars" <mjbaars1977.pg...@gmail.com> writes:
> > Somewhere in between release 16.3 and
> > release 16.9, changes must have been implemented that make the execution
> > engine about two times slower than it was.
>
> That seems quite unlikely, and you've surely provided no details that
> would help identify any such problem.  My own first guess is that the
> newer install was somehow built with debugging assertions enabled
> (configure's --enable-cassert option).  Those are pretty heavyweight
> and could possibly account for this.  A second guess is that you were
> relying on JIT compilation and the newer install somehow omitted that
> (failed to use --with-llvm).  Anyway, I'd start by comparing the
> output of pg_config from both installs.

Thanks for the tip!

These are the difference I find:

16.3 is built with

--sbindir=/usr/sbin

16.9 is built with

--sbindir=/usr/bin
-mtls-dialect=gnu2
-DOPENSSL_NO_ENGINE
-std=c17

Could these have the same effect to some degree?

Neither was built with --enable-cassert or --with-llvm.

>                         regards, tom lane

Reply via email to