RE: Access plan selection logic PG9.2 -> PG14

Поиск
Список
Период
Сортировка
От Ryo Yamaji (Fujitsu)
Тема RE: Access plan selection logic PG9.2 -> PG14
Дата
Msg-id TYAPR01MB6073C17B86AE4005DF5316178AF6A@TYAPR01MB6073.jpnprd01.prod.outlook.com
обсуждение исходный текст
Ответ на Re: Access plan selection logic PG9.2 -> PG14  (Adrian Klaver <adrian.klaver@aklaver.com>)
Список pgsql-general
on Fri, 15 Sept 2023 at 0:00, Adrian Klaver <adrian.klaver@aklaver.com> wrote:
> Why not just run ANALYZE on the new 14.7 instance?

The statistics were manually updated to fix the access plan.
I was trying to see if I could fix the access plan in a similar way in 9.2 -> 14.7.

I probably will run ANALYZE soon because I haven't been able to achieve the access plan I want.


Regards, Ryo

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

Предыдущее
От: "Ryo Yamaji (Fujitsu)"
Дата:
Сообщение: RE: Access plan selection logic PG9.2 -> PG14
Следующее
От: David Rowley
Дата:
Сообщение: Re: Access plan selection logic PG9.2 -> PG14