Re: PgSQL 15.3: Execution plan not using index as expected

Поиск
Список
Период
Сортировка
От Adrian Klaver
Тема Re: PgSQL 15.3: Execution plan not using index as expected
Дата
Msg-id fd6c587b-6694-aeb3-063d-38b3243dc455@aklaver.com
обсуждение исходный текст
Ответ на PgSQL 15.3: Execution plan not using index as expected  (Dürr Software <info@fduerr.de>)
Список pgsql-general
Дерево обсуждения 
On 8/9/23 01:14, Dürr Software wrote:
> Dear list,
> 
> i have a strange problem when migrating a DB from version 9.3.4 to 15.3:
> An index which seems perfect for the query and is used in 9.3.4 as 
> expected is not used in 15.3.

Did you run ANALYZE on the 15.3 database after the migration?


-- 
Adrian Klaver
adrian.klaver@aklaver.com

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