Difference in execution plans pg12 vs pg14 - Mailing list pgsql-general

From Дмитрий Иванов
Subject Difference in execution plans pg12 vs pg14
Date
Msg-id CAPL5KHqvmUdJ7YAwFY0=oNihTYpyg8pvhTLNed2Fs3GiPbH12g@mail.gmail.com
Whole thread Raw
Responses Re: Difference in execution plans pg12 vs pg14  (Adrian Klaver <adrian.klaver@aklaver.com>)
Re: Difference in execution plans pg12 vs pg14  (Imre Samu <pella.samu@gmail.com>)
Re: Difference in execution plans pg12 vs pg14  ("Peter J. Holzer" <hjp-pgsql@hjp.at>)
List pgsql-general
Afternoon. I was able to make the necessary changes to my base needed to migrate win_pg12 to debian pg14.
But there is a new problem, which was not there at the initial stage so I checked:

win_pg12:
->  Index Scan using index_class_tree_full on class c  (cost=0.28..2.50 rows=1 width=235) (actual time=0.030..0.032 rows=1 loops=1)
                     Index Cond: (id = 650)
debian_pg14:  
->  Index Scan using index_class_tree_full on class c  (cost=0.28..2.50 rows=1 width=235) (actual time=842.795..842.796 rows=1 loops=1)
                     Index Cond: (id = 650)

I'm wondering where to dig next...
--
Best regards, Dmitry!
Attachment

pgsql-general by date:

Previous
From: Richard Michael
Date:
Subject: Re: CTE Materialization
Next
From: Adrian Klaver
Date:
Subject: Re: Difference in execution plans pg12 vs pg14