Difference in execution plans pg12 vs pg14

Поиск
Список
Период
Сортировка
От Дмитрий Иванов
Тема Difference in execution plans pg12 vs pg14
Дата
Msg-id CAPL5KHqvmUdJ7YAwFY0=oNihTYpyg8pvhTLNed2Fs3GiPbH12g@mail.gmail.com
обсуждение исходный текст
Ответы 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>)
Список 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!
Вложения

В списке pgsql-general по дате отправления:

Предыдущее
От: Richard Michael
Дата:
Сообщение: Re: CTE Materialization
Следующее
От: Adrian Klaver
Дата:
Сообщение: Re: Difference in execution plans pg12 vs pg14