Re: Upgrade from Fedora 40 to Fedora 42, or from PostgreSQL 16.3 to PostgreSQL 16.9

2025-07-20 Thread Michael J. Baars
On Sun, Jul 20, 2025 at 10:13 AM Michael J. Baars wrote: > > On Sat, Jul 19, 2025 at 5:36 PM Tom Lane wrote: > > > > "Michael J. Baars" writes: > > > Compiling from source with a default ./configure --prefix=/usr/local > > > solves the problem. > > > > Cool. I confess I have no idea what the tr

Re: Upgrade from Fedora 40 to Fedora 42, or from PostgreSQL 16.3 to PostgreSQL 16.9

2025-07-20 Thread Michael J. Baars
On Sat, Jul 19, 2025 at 5:36 PM Tom Lane wrote: > > "Michael J. Baars" 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

Re: Upgrade from Fedora 40 to Fedora 42, or from PostgreSQL 16.3 to PostgreSQL 16.9

2025-07-19 Thread Tom Lane
"Michael J. Baars" 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

Re: Upgrade from Fedora 40 to Fedora 42, or from PostgreSQL 16.3 to PostgreSQL 16.9

2025-07-19 Thread Michael J. Baars
On Fri, Jul 18, 2025 at 4:09 PM Tom Lane wrote: > > "Michael J. Baars" 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 pro

Re: Upgrade from Fedora 40 to Fedora 42, or from PostgreSQL 16.3 to PostgreSQL 16.9

2025-07-19 Thread Michael J. Baars
On Fri, Jul 18, 2025 at 4:09 PM Tom Lane wrote: > > "Michael J. Baars" 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 pro

Re: Upgrade from Fedora 40 to Fedora 42, or from PostgreSQL 16.3 to PostgreSQL 16.9

2025-07-18 Thread Tom Lane
"Michael J. Baars" 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. M

Re: Upgrade from Fedora 40 to Fedora 42, or from PostgreSQL 16.3 to PostgreSQL 16.9

2025-07-18 Thread Ashutosh Bapat
Hi Michael, On Fri, Jul 18, 2025 at 3:01 PM Michael J. Baars wrote: > > Hello fellow PostgreSQL users and developers, > > I installed a new Fedora release last week and ran into a peculiar problem: > > Each night I need to run computations through about 70.000 rows and using > release 16.3 that

Upgrade from Fedora 40 to Fedora 42, or from PostgreSQL 16.3 to PostgreSQL 16.9

2025-07-18 Thread Michael J. Baars
Hello fellow PostgreSQL users and developers, I installed a new Fedora release last week and ran into a peculiar problem: Each night I need to run computations through about 70.000 rows and using release 16.3 that took about 4 hours to complete, but using release 16.9 the same computations now ta