On Sun, Jul 20, 2025 at 10:13 AM Michael J. Baars <mjbaars1977.pg...@gmail.com> wrote: > > On Sat, Jul 19, 2025 at 5:36 PM Tom Lane <t...@sss.pgh.pa.us> wrote: > > > > "Michael J. Baars" <mjbaars1977.pg...@gmail.com> writes: > > > Compiling from source with a default ./configure --prefix=/usr/local > > > solves the problem. > > > > Cool. I confess I have no idea what the triggering difference > > was, because the extra options you mentioned before don't look > > performance-relevant. I guess -DOPENSSL_NO_ENGINE could hurt > > SSL encryption speed, but unless your workload involved shoving > > huge amounts of data over an SSL connection, it doesn't seem > > like that would amount to much. Anyway, probably not worth > > expending additional brain cells on. > > The funny thing is, that ssl is unset in the config files and the > default is ssl=off.
That is because the problem was not SSL related :) The problem was related to lots of errors that were written to the log file during query execution. Errors like: ERROR: found xmin from before relfrozenxid The errors originated from the database migration, that was partially done in binary mode and should have been done in text mode instead. Execution time has actually improved over version 16.3. Query 1 over unix sockets: Time: 122.239 ms Time: 123.551 ms Time: 122.298 ms Time: 123.282 ms Regards, Mischa.
